[RESOLVED] SQL Search for rows within 120 mins

[NZ_Kiwis]

I want to do a search for the follow

SELECT * FROM myRecords WHERE Code = '$Code' AND MyUnixTimeStamp (is within 120mins of now)

How can I do this?

Also can I plus the returned results into a variable without looping results doing $i++?

[dagon]

... MyUnixTimeStamp <NOW + INTERVAL 120 MINUTES ...

[NZ_Kiwis]

yes but that does not work

arning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in J:\wamp\www\main.php on line 9

[dagon]

what does not work?

[bradgrafelman]

In dagon's post above, the 'NOW' should have been a function call; see NOW() in the MySQL manual.

In addition, note that the INTERVAL keyword expects the unit name to be singular, so you'd use 'MINUTE' rather than 'MINUTES' (yes, saying something like '30 MINUTE' sounds horribly wrong, but alas that's what MySQL expects). See the MySQL manual page for DATE_ADD() for more info, as it explains how to use the INTERVAL keyword.