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.. 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? 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. =) Link to comment https://forums.phpfreaks.com/topic/198300-between/#findComment-1040468 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.