Re: a lil problem with graffs....... problem caught solution required plz

o jeez is that the reason nobdy replied???? guyz ???? :'( (U) toby .... --- Stephen <stephen.edmonds5@btinternet.com> wrote: > For the record > > its graphs > > Not graffs ;-) > > When I first saw the subject line I thought you were talking about > Giraffes... (African thing, long necks...) > > ----- Original Message ----- > From: "toby z" <blue_myth_1@yahoo.com> > To: "toby z" <blue_myth_1@yahoo.com>; "php hlp list" > <php-windows@lists.php.net> > Sent: Wednesday, May 07, 2003 12:36 PM > Subject: Re: [PHP-WIN] a lil problem with graffs....... problem > caught > solution required plz > > > > well i guess i was a bit too blind to have not seen the solution > > > > a little > > > > $gfData = ""; > > > > between the two calls to rprt_grf.php page did it all > > > > thnx a mill anyways guyz > > pretty :) > > toby ..... > > > > --- toby z <blue_myth_1@yahoo.com> wrote: > k guyz heres the > problem > > > > > > > > > > > > > > > heres the code > > > > > > for($loop_mon=$frm_mon; $loop_mon<=$to_mon ; $loop_mon++){ > > > > > > > > > $ftch_dta_rprt_1_qry = "select count(date) from tbl_vill_398 > > > where month(date) = $loop_mon > > > and year(date)=$yr"; > > > > > > $ftch_dta_rprt_1_qry_rzlt_hndlr = > mysql_query($ftch_dta_rprt_1_qry) > > > or die(); > > > > > > > > > $ttl_rkz_ftchd = > mysql_num_rows($ftch_dta_rprt_1_qry_rzlt_hndlr); > > > > > > > > > $ftch_rprt_data = > mysql_fetch_row($ftch_dta_rprt_1_qry_rzlt_hndlr); > > > > > > $rprt_data= $ftch_rprt_data[0]; > > > > > > $gfData[] = $rprt_data; > > > > > > > > > > > > > > > include"ftch_mon_nmz.php"; > > > > > > > > > $rprt_dt_arr = $rprt_dt_arr.",".$rprt_data; > > > > > > } > > > include "rprt_gf.php"; > > > > > > > > > //repeat all this procedure for query 2 ! ! ! ! > > > > > > for($loop_mon_=$frm_mon; $loop_mon_<=$to_mon ; $loop_mon_++){ > > > > > > > > > $ftch_dta_rprt_2_qry = "select count(date) from tbl_vill_398 > > > where month(date) = $loop_mon_ > > > and year(date)=$yr "; > > > $ftch_dta_rprt_2_qry_rzlt_hndlr = > > > mysql_query($ftch_dta_rprt_2_qry) > > > or die("qry $ftch_dta_rprt_1_qry failed ! <br> da tbl must > xixt in > > > da db 2 b played vid ! ! ! !<br>".mysql_error()); > > > > > > > > > > > > $ttl_rkz_ftchd_2 = > > > mysql_num_rows($ftch_dta_rprt_2_qry_rzlt_hndlr); > > > > > > > > > $ftch_rprt_data_2 = > > > mysql_fetch_row($ftch_dta_rprt_2_qry_rzlt_hndlr); > > > $rprt_data_2= $ftch_rprt_data_2[0]; > > > > > > $gfData[] = $rprt_data_2; > > > > > > > > > > > > > > > include"ftch_mon_nmz.php"; > > > > > > $rprt_dt_arr_2 = $rprt_dt_arr_2.",".$rprt_data_2; > > > > > > } > > > include "rprt_gf.php"; > > > > > > > > > ---------------------------------- > > > rprt_gf.php > > > ---------------------------------- > > > > > > > > > > > > for ($i = 0; $i < $max_data; $i++) > > > { > > > if ($arrData[$i] > $max_value) > > > $max_value = $arrData[$i]; > > > > > > if ( strlen($label[$i]) > $max_label_width ) > > > $max_label_width = strlen($label[$i]); > > > > > > $table_text = $table_text . "<th>" . $label[$i] . > > > "</th>"; > > > } > > > > > > $table_text = $table_text . "</tr>"; > > > > > > //$x = $max_label_width * $font_width + 10; > > > $height = ($max_data * ($bar_width + $bar_gap)) - 10; > > > $width = $max_value + $x + 150 ; > > > > > > $bar_x = $max_label_width * $font_width + $x + 5; > > > > > > $im = ImageCreate($width, $height); > > > // Allocate colors > > > $white = ImageColorAllocate($im, 255, 255, 255); > > > $yellow = ImageColorAllocate($im, 240, 240, 70); > > > $blue = ImageColorAllocate($im, 0, 64, 128); > > > $bar = ImageColorAllocate($im, 64, 100, 168); > > > $light_grey = ImageColorAllocate($im, 192, 192, 192); > > > $black = ImageColorAllocate($im, 0, 0, 0); > > > > > > $lightest_grey = ImageColorAllocate($im, 210, 210, 210); > > > > > > // Background > > > ImageFilledRectangle($im, 0, 0, $width, > $height,$lightest_grey); > > > //imagerectangle($im, 0, 0, $width, $height, $black); > > > // Title > > > //ImageString($im, 3, $title_x, 0, $title, $white); > > > > > > $table_text = $table_text . "<tr>"; > > > > > > for ($i = 0; $i < $max_data; $i++) > > > { > > > ImageString( > > > $im, 3, $x, $y + ($i * $bar_gap) , > > > $label[$i], $black > > > ); > > > $px = $x + 100 + $arrData[$i]; > > > > > > // Draw rectangle value > > > imagefilledrectangle( $im, > > > $bar_x, > > > $y + ($i * $bar_gap), > > > $px, > > > $y + ($i * $bar_gap) + $bar_width , > > > $black); > > > > > > ImageString( > > > $im, 3, $bar_x, $y + ($i * $bar_gap)+ $bar_width , > > > "(".$gfData[$i] . ")", $black > > > ); > > > > > > $table_text = $table_text . "<td style= \"font-family: $font\" > >" > > > . > > > $gfData[$i] . "</td>"; > > > } > > > $table_text = $table_text . > > > "</tr></table></td></tr>"; > > > > > > if($max_data>1){ > > > > > > ImageJpeg($im, $tz);// Png($im); > > > > > > // Release allocated resources > > > ImageDestroy($im); > > > } > > > > > > echo($table_text); > > > > ----------------------------------------------------------------- > > > > > > > > > the problem : > > > $gfData[] > > > its being sent to the rprt_grf.php file twice > > > i think i have to empty the array before i fill it again > > > but how the devil do i do that > > > > > > or am i wrong here > > > > > > can n will someone plz help > > > eternally thankfull > > > > > > toby..... > > > > > > > > > > > > > > > > > > --- toby z <blue_myth_1@yahoo.com> wrote: > hi guyz > > > > > > > > just a pessky little problem > > > > > > > > > > > > ---------------------------------- > > > > ImageJpeg($im, $tz);// Png($im); > > > > > > > > // Release allocated resources > > > > ImageDestroy($im); > > > > ---------------------------------- > > > > > > > > this dammed piece of code aint seem to be working > > > > it creates a graph all well > > > > but im sure it aint destroying it > > > > > > > > as im creating two graphs on a page > > > > and the second graph appears as a copy of the first > > > > onlt the first shows records for jan, feb and march > > > > the second otta show records for the same months > > > > it shows jan, feb, march records of the 1st graph > > > > and then thee records for april > > > > and these are the values it otta show for jan, feb and march > > > > > > > > i no i sound lost > > > > as i very much am > > > > > > > > what m i to do with this > > > > ImageDestroy($im); > > > > thinggy ????? > > > > > > > > > > > > thnx a mill > > > > lost > > > > toby ..... > > > > > > > > > > > > __________________________________________________ > > > > Yahoo! Plus > > > > For a better Internet experience > > > > http://www.yahoo.co.uk/btoffer > > > > > > > > -- > > > > PHP Windows Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: > > > > http://www.php.net/unsub.php > > > > > > > > > > __________________________________________________ > > > Yahoo! Plus > > > For a better Internet experience > > > http://www.yahoo.co.uk/btoffer > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > __________________________________________________ > > Yahoo! Plus > > For a better Internet experience > > http://www.yahoo.co.uk/btoffer > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > __________________________________________________ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer