agallant Posted March 10, 2005 Share Posted March 10, 2005 I have a site that people get emailed registration codes to. When they go to the site there is a box that asks for them to enter there code. If they put in a correct code it pulles there record if they put ion no code or mistype there code the get the following error message You have an error in your SQL syntax near '' at line 1 How do i change the error message? If it could just say some thing like invalid code please use your back button to try agian would be good enoughf. Thanks, AG Link to comment https://forums.phpfreaks.com/topic/2201-how-to-change-error-message/ Share on other sites More sharing options...
micah1701 Posted April 22, 2005 Share Posted April 22, 2005 You have an error in your SQL syntax near '' at line 1 How do i change the error message? If it could just say some thing like invalid code please use your back button to try agian would be good enoughf. 212788[/snapback] You need to modify the php script where it queries the database looking to match the dbase with the users submitted code. find where it says something similar to: die(mysql_error()) and change "mysql_error()" to whatever error message you want, so it looks like: die("sorry, invalid entry") Link to comment https://forums.phpfreaks.com/topic/2201-how-to-change-error-message/#findComment-7459 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.