Jump to content

Archived

This topic is now archived and is closed to further replies.

everythingandtwo

Need help with a select statement

Recommended Posts

If I\'m wanting to select records from a database between two numbers, what would be the best way to write the SQL statement for it?

 

Here\'s what I have currently, but for some reason it doesn\'t work...

 

SELECT * FROM guestbook_main WHERE entry_num >= " . $min . " and entry_num <= " . $max . " ORDER BY entry_num DESC;

 

This doesn\'t return anything, but if I take off the \"and entry_num <= $max\" part of it, it will return all of the entries. I tried using BETWEEN but it didn\'t work either.

 

Can anyone help me out?

 

Thanks,

Brad[/code]

Share this post


Link to post
Share on other sites

Try this query

 

SELECT * FROM guestbook_main WHERE entry_num between  \'$min\' and \'$max\' ORDER BY entry_num DESC

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.