Query
| From: | peppe | Date: | Tue, 24 Feb 2004 16:20:19 +0000 |
| Subject: | Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33099@lists.php.net to get a copy of this message | ||
Hi I have this query
$sql = "SELECT * FROM events WHERE ( YEAR(datum) = '" . $year . "') ORDER
BY
datum ASC";
$result = mysql_query($sql);
$numRows = mysql_num_rows($result);
for ($row = 1; $row <= $numRows; $row++) {
$rowArray = mysql_fetch_array($result);
$datum = $rowArray["datum"];
$title = $rowArray["title"];
$datum = date("d-m-Y", strtotime($datum));
$datum is 20-02-2004
?>
I want to show here the events by month for example table with events of
02(February) then if there are events from 03(March) another table and so
one
How can I make this work do I need to make another query
Any idea