Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux