bira
Mon 9th Apr '01, 8:34am
Hi,
I need to run a select that would look like this:
SELECT * FROM choices WHERE update<'$time' AND
(choice1='1' OR choice4='1' OR choice5='1')
What I mean to say is that I need to get all the rows where the last update was before a certain time ($time) AND one of the choices (choice1 OR choice4 OR choice5) equals 1.
Can anyone tell him how to correctly write this line? Have I written it correctly here?
Thanks!
Bira
I need to run a select that would look like this:
SELECT * FROM choices WHERE update<'$time' AND
(choice1='1' OR choice4='1' OR choice5='1')
What I mean to say is that I need to get all the rows where the last update was before a certain time ($time) AND one of the choices (choice1 OR choice4 OR choice5) equals 1.
Can anyone tell him how to correctly write this line? Have I written it correctly here?
Thanks!
Bira