SQL Problem (Syntax)

[Blazer06]

This doesn't work:

$query= SELECT date, author, name, idnum FROM articles WHERE date>'$start' and date<'$stop' order by date;";

But this does:
$query= "SELECT date, author, name, idnum FROM articles WHERE date>'$start' order by date;";

However, the former works on PHP MyAdmin on a differnt database & server.

Any help?

EDITED TO NOT BORK UP THE QUICK VIEW WINDOW


Blaze

[Gomer]

i dunno... but you borked the "recent display" box in firefox.

[Blazer06]

I know! I borked it for Opera tooooooo!!

Do i get a prize?


Blaze

[M_Six]

In IE, too.

[Blazer06]

Ohhh Ohhhh THREE browsers baby!!!

Wait... I don't want to break TIMO.

Anywho... anybody have any help on the SQL?


Blaze

[Blazer06]

Still havent figured it out? ANYBODY?


Blaze

[Creosote]

You're missing a double quote at the beginning of the statement.

[Blazer06]

No, that is not the problem. I had to take the double quote out because if I leave it in it messes up TIMO in the recent threads box. (???)


Blaze

[Creosote]

Try BETWEEN instead of AND

[Blazer06]

NICE. works now. (between '$start' and '$stop')


Blaze