[Resolved] BETWEEN operator

[asa_carter]

Hi,

I'm trying to select everything in a database where the end of an auction (datetime stored in a dateabase) is between now and the next 5 minutes but I cant seem to get the right syntax. Can anyone help?

$item = mysql_query("SELECT id, item FROM item WHERE auction_end BETWEEN now() AND (now(), INTERVAL 5 MINUTE)", $mysql_access);

Thanks,

Asa.

[tsinka]

Hi,

try something like:

SELECT id, item FROM item WHERE auction_end BETWEEN NOW() AND DATE_ADD(NOW(),INTERVAL 5 MINUTES)

Thomas

[asa_carter]

Hi,

Thanks but thats still throwing up an error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/ixdipfd/public_html/marketplace/index.php on line 105

Anybody know whats wrong with it?

Regards

Asa.

[tsinka]

Change the code to

mysql_query("SELECT ....") or die ("SQL error: ".mysql_error());

That should print an error message.

Thomas

[asa_carter]

SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MINUTES))' at line 1

[asa_carter]

Hi,

Changed the MINUTES to MINUTE and it works fine now

Cheers,

Asa