query

[Anon]

Hi can anyone tell me what is wrong with this, i'm trying to select everything between a specific date, it doesn't throw up any errors, but it doesn't pull out any results either, and i know there are some.

$query = "SELECT * FROM data WHERE date >= 2001-04-01 AND date <= 2001-04-30";

thanks Martin

[Anon]

SELECT * FROM data WHERE date >= '2001-04-01' AND date <= '2001-04-30'
ry with single quotes

[Anon]

fantastic, thanks very much, i feel so stupid now 🙂