Search found 10 matches

by menjada
Sun Feb 09, 2003 11:42 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

Hi again. Thanks for the help last time. I know this is not the right thread to be. But i want to continue our disskution. If i want to LIMIT the last 30 rows regarding the amount of rows in the table. The table kan include rows from different months. So i want only to disply the last 30 days. /Jörgen
by menjada
Thu Feb 06, 2003 9:56 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

U are my HERO!!!!!!!!!!!!

Thanks so mutch!!

If i want to make a limit of 50?

/Jörgen
by menjada
Thu Feb 06, 2003 6:11 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

I got this error??

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in example222.php on line 7

JpGraph Error: Empty data array specified for plot. Must have at least one data point.
by menjada
Thu Feb 06, 2003 3:34 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

The structure is. annons_id | date | impressions | spela | clicktrough ------------------------------------------------------------- 0023 | 2003-03-03 | 55 | 12 | 3 0023 | 2003-03-04 | 60 | 10 | 5 Creates a new row depending on date. And updates the row depending on date. But the tabel can include d...
by menjada
Wed Feb 05, 2003 11:29 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

I still don´t get it. The script, works but it only displays like this: m Are eval("\$data1y = array(" .$out['impressions']. ");"); making a total of the impressions? I have at least 10 rows in the database whit differa ent dates, it should be 10 bars (one bar is actally 3, data1, data2 and data3 ar...
by menjada
Wed Feb 05, 2003 5:51 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

i´m VERY sorry. But i don´t understand myself some times. The database structure is a table whit these columns: date, impressions, spela, clicktrough The row is being updated by day I want to output like example: m there 0 is a date and 1 is another date. the output is like impressions = (5,7,etc......
by menjada
Wed Feb 05, 2003 5:19 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

OK here is the hole script and with URL preview: This code: $data1y=array(5,6,5,6,);//impressions $data2y=array(5,6,5,6); //clicks $data3y=array(5,6,5,6,);// clicktroughs OUTPUTS: m This code: $sql = mysql_query("SELECT impressions, spela, clicktrough FROM mon01 WHERE annons_id = '00023'"); $data_co...
by menjada
Wed Feb 05, 2003 4:58 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

I´m AND IDIOT! i didn´t defined the table, there fore the error in output. Question? when U say: should result in data1y = array(123,4,56,78,9,0); data2y = etc is data1y imressions, or is data1y and data2y the same variable but splittet in 2?? Because data2y is another datasource. I add an updated s...
by menjada
Wed Feb 05, 2003 4:16 am
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

Ok i´m stupit. I get error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource, on line 7 JpGraph Error: Empty data array specified for plot. Must have at least one data point. CODE: $sql = mysql_query("SELECT impressions FROM $table WHERE annons_id = '00023' ORDER ...
by menjada
Tue Feb 04, 2003 1:18 pm
Forum: PHP coding => Images
Topic: Help to disply data in image
Replies: 18
Views: 9772

Help to disply data in image

My speciallity is not PHP. Therfore i ask u to help me. I use the JPgraph to make a graph. Bu i need convert? my sql/php question to this variabel: $data1y=array(112,8,19,3,10,5); Some sort of array i think. My SQl/php question: $sql = mysql_query("SELECT impressions FROM $table WHERE annons_id = '$...