Query works in phpMyAdmin, but not when I run it from my own script

Hi, I'm using this query in my script:

$query = "select * from Birthdays where Date >= '".$start_date."' AND Date <= '".$end_date."' ";

But it doesnt work. It says that the result is not a valid mysql result resource.

it works in phpMyAdmin when I use the following query:

select * from Birthdays where Date >= '20030801' AND Date <= '20040201'

does anyone know why it isnt working in my script?

cheers,

Jason

Bad use of reserved word in fieldnames.

Put backticks around date to get it to be accepted.

$query =  "select * from Birthdays where `Date` >= '$start_date' AND `Date` <= '$end_date' ";

hth

thanks for replying so quickly,

I have already tried putting backticks in and it still doesnt work... any other ideas?

thanks,

Jason

Try formatting $start_date as '2003-08-01', as that's how mysql holds it

nope... didnt work.

Thanks for the suggestion though

Is Date actually a DATE or DATETIME field?

OMG... i cant believe i was so stupid...

thanks for all your help barand, and sorry for wasting your time.

I hadnt even connected to the database... Amateur mistake...

thanks for your time Barand