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 Quote Link to comment 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") Quote Link to comment 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.