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
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php