Jump to content

Archived

This topic is now archived and is closed to further replies.

agallant

How to change error message

Recommended Posts

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

Share this post


Link to post
Share on other sites

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")

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.