how to find if the query was successful

[Leena P]

I have a insert query which is fired when the form is submitted sometimes users enters illegal characters or for some reason query is not executed properly
how to find if the query has run successfully or not

[code green]

Very bad practice. Always cleanse form data BEFORE inserting into a database.
By cleanse I mean protect from SQL injection and validate the data.
As for checking if queries work, php query execution functions do return error codes.
And there are rows affected functions.
I cannot be more helpful because you omitted your DB engine

[carmarri]

It's true, you should ensure that the data is correct before launch the query, otherwise you can have even security problems on your Database system.

Anyway you can check a response:

$result = mysql_query("SELECT....",$db);
if ($result===false)
{
 echo "error!"
} else {
 //actions....
}

Regards,


-------------------------------------
xatcom.net, diseño web

[kovik]

~carmarri, the OP stated that they were using an INSERT query. INSERT and UPDATE queries do not create result resources, as they have no results.