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

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 > >