Hi John, As you mentioned in your mail, I had placed the "mysql_error()" function in the code and the error got trapped.
The entry is not saved when single quotes ( ' ) was used while entering any text. How to avoid this? Can it be filtered while saving it to mysql database (or) is there anyway to validate the text field while the form is entered. Regds R.Vijay On Sat, Jul 5, 2008 at 9:28 PM, John Black <[EMAIL PROTECTED]> wrote: > Vijayaraghavan R wrote: > > Hi, > > I have developed an online form which is used by my company's marketing > > staff. > > When I try to enter the form I never get any errors and it gets saved > > properly. > > Could be a database error, maybe too many connections. > > Change the line > echo '<p><font color="BLUE">ERROR !!! D W R NOT Saved !!! </font></p>'; > > to > echo '<p><font color="BLUE">ERROR !!! D W R NOT Saved !!! <br > />'.mysql_error().'</font></p>'; > > This will also output any errors from the database, if there are any. > > I would also suggest you check the Webserver and Database server's logs > around the time of the reported errors to see if they contain a clue. > > -- > John > > > [Non-text portions of this message have been removed]
