Re: help - get results in an order !

Well solved it ... I create a form with hidden values the results of the database..:) but ANY good program to draw an nice 2d or 3d graph ??? or bar chart ??? -- ~~~~~~~~~~~~~~~~ Sapilas@/dev/pinkeye ~~~~~~~~~~~~~~~~ "Septic Flesh" <septic_flesh@hotmail.com> wrote in message news:20020619143914.48780.qmail@pb1.pair.com... > Well i made the following sql query with the loop... > > ----------------------------------------------------------- > // execute the query to get no of visitors per day > for ($day = 1 ; $day <32 ; $day++) > { > // loop the query 31 times, one for each day of month > $query = "select * from tracker > where day='$day' > and month='$month' > group by sess_id"; > $result = mysql_query($query); > echo "<div align=right><b><font color=red>"; > echo mysql_num_rows($result); > echo "</b></font></div>"; > > --------------------------------------------- > > > > and I get the following result: > > > > 1 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 3 > 4 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > 0 > > which is correct, but how can I declare the first and the second and the > last results seperatly? > > I wanna use them to plot a graph... > > thanks in advance.. > > -- > ~~~~~~~~~~~~~~~~ > > Sapilas@/dev/pinkeye > > ~~~~~~~~~~~~~~~~ > >