getting the date

ade1982

I have a MySQL table that looks something like this

id venue date
1 London 2006-03-10
2 Paris 2005-02-12
3 New York 1996-12-12

and I need to construct a statement such as

$data = mysql_query("SELECT * FROM table1 WHERE date = '$string'");
while ($info = mysql_fetch_array( $data )){
          echo $info['venue'];
}

where $string is either 1996,1997, 1998 ... 2006

I think it has to be done in 2 statements, but I would be guessing

Can anyone help?

As always, thank you!

matt72

One way is to make a date range and get all the dates within that range.

$start_date = '1996-01-01';
$end_date = '1996-12-31';
$data = mysql_query("SELECT * FROM table1 WHERE date >= '$start_date' AND date <= '$end_date'");

Installer

SELECT * FROM table1 WHERE YEAR(date) = '$string'

MySQL Date and Time Functions