Re: mysql question

Yes, though I'd probably add parentheses to make it clearer. select * from table where ((start_shot <= $current_shot) and (end_shot >= $current_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 >= $current_shot note everything will be of type INT Thanks ya'll -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php