moraaaa Posted April 25, 2007 Share Posted April 25, 2007 hello i have two columns in a db they all numeric Supposing that this is the view of the db from to rate 1 9 perfect 10 19 good 20 29 bad etc... the user will put a number i want to SELECT rate FROM thetable where is user input belong to ex. if user wrote 6 show perfect if 15 show good I should be grateful to those who give me a solution sorry for my english waiting for reply Link to comment https://forums.phpfreaks.com/topic/48681-solved-how-to-search-in-number-limit/ Share on other sites More sharing options...
Anzeo Posted April 25, 2007 Share Posted April 25, 2007 SELECT rate FROM db WHERE from =< $input AND to => $input Not sure though. You could give it a try. Link to comment https://forums.phpfreaks.com/topic/48681-solved-how-to-search-in-number-limit/#findComment-238454 Share on other sites More sharing options...
moraaaa Posted April 25, 2007 Author Share Posted April 25, 2007 Thank you this worked for me "SELECT * FROM tbl WHERE from <='$value' AND to >='$value'" Link to comment https://forums.phpfreaks.com/topic/48681-solved-how-to-search-in-number-limit/#findComment-238517 Share on other sites More sharing options...
Anzeo Posted April 25, 2007 Share Posted April 25, 2007 Glad I could help you out^^ Link to comment https://forums.phpfreaks.com/topic/48681-solved-how-to-search-in-number-limit/#findComment-238529 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.