techker Posted April 12, 2010 Share Posted April 12, 2010 Hey guys im doing this car dealer ship script and im stuck on a query. so i have search criteria's like by make ,color.. i have some for killometres. 60 to 90 90 to 110 110 to 160.. how can i make a query that i will search my killometre colome for cars between 60 and 90 clicks.. Quote Link to comment https://forums.phpfreaks.com/topic/198300-between/ Share on other sites More sharing options...
techker Posted April 12, 2010 Author Share Posted April 12, 2010 Hey guys im doing this car dealer ship script and im stuck on a query. so i have search criteria's like by make ,color.. i have some for killometres. 60 to 90 90 to 110 110 to 160.. how can i make a query that i will search my killometre colome for cars between 60 and 90 clicks.. ok i think i got it. SELECT * FROM `cars` WHERE `Kill` BETWEEN 60000 AND 120000 LIMIT 0 , 30 is this good? Quote Link to comment https://forums.phpfreaks.com/topic/198300-between/#findComment-1040455 Share on other sites More sharing options...
Ken2k7 Posted April 12, 2010 Share Posted April 12, 2010 Run it. Looks good to me. =) Quote Link to comment https://forums.phpfreaks.com/topic/198300-between/#findComment-1040468 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.