goatboy Posted October 5, 2005 Share Posted October 5, 2005 i made a search to search order numbers, if you input numbers it works correctly even if its an order number that doesn't exist it just tells you that but i tested if someone where to type text, and i get a mysql error, shouldn't it do the same thing as if it were an order number that didn't exsit? Quote Link to comment https://forums.phpfreaks.com/topic/2618-php-mysql-search-problem/ Share on other sites More sharing options...
effigy Posted October 5, 2005 Share Posted October 5, 2005 numbers do not have to be quoted; text does. i would use some validation, such as is_numeric, before passing the data to mysql. Quote Link to comment https://forums.phpfreaks.com/topic/2618-php-mysql-search-problem/#findComment-8683 Share on other sites More sharing options...
goatboy Posted October 5, 2005 Author Share Posted October 5, 2005 thanks, that solves my problem Quote Link to comment https://forums.phpfreaks.com/topic/2618-php-mysql-search-problem/#findComment-8684 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.