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? 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. 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 Link to comment https://forums.phpfreaks.com/topic/2618-php-mysql-search-problem/#findComment-8684 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.