help - get results in an order !
| From: | Septic Flesh | Date: | Wed, 19 Jun 2002 14:45:38 +0000 |
| Subject: | help - get results in an order ! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102945@lists.php.net to get a copy of this message | ||
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
~~~~~~~~~~~~~~~~