Yes, though I'd probably add parentheses to make it clearer.

select * from table where ((start_shot <= $current_shot) and (end_shot >=

Though that's probably not necessary. Make certain you have your less 
than's and greater thans set the right way, I've often sat slack-mouthed 
wondering why I had no data, simply because I was using "<" when it should 
have been ">".

Cheers - Miles Thompson

At 12:06 PM 7/11/2002 -0400, Alexander Ross wrote:
>I realize this isn't a php question, but I figured that someone here knows
>of a good mysql newsgroup and in the mean time someone here probaby knows
>the answer to my question.
>Can I set up a query like this:
>select * from table where start_shot <= $current_shot and end_shot >=
>note everything will be of type INT
>Thanks ya'll
>PHP General Mailing List (
>To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to