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

From: Date: Wed, 07 May 2003 10:23:29 +0000
Subject: Re: a lil problem with graffs....... problem caught solution required plz
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-19796@lists.php.net to get a copy of this message
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

« previous php.windows (#19796) next »