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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php