Page 1 of 1

How to combine WHERE and BETWEEN

Posted: Sun May 29, 2011 9:38 am
by Peter Kelly
I'm currently making an APi system on my website. I need to choose from the api_requests table where

app_id = "3" and time between 2705100700 and 2705101000.

I can do both seperately but I dunno how I can combine that in one query.

Re: How to combine WHERE and BETWEEN

Posted: Mon May 30, 2011 2:31 pm
by pickle
what you've got there is perfectly fine. The "AND" after the app_id clause is considered a boolean comparitor, but the AND between your two time values is not.