Re: error handling in query execution

Chenri wrote:

i have a script that update records with this construct: while( .... ){

     query_string='UPDATE  .......';
     updateRecord(query_string);

} the problem is when there are wrong query_string (such as incorect syntax) can i make sure that the other query, the next one after the wrong query still goes. I've read about the @ operand but i still doesn't understand does the script stop when the error occured or does it still continue the process

Cherni, your updateRecord() function must handle the query error thats all. the '@' sign is there to repress errors so that they don't show up on screen or in your log. you may need to use the '@' to stop a warning from being emitted when you pass a bad query.... (you don't say which DB you use and I haven't used mysql in a long time) whether or not the script stops depends on what kind of error occurs. FATAL errors are exactly that, WARNINGs don't always need to be a show stopper it depends on your error checking/handling. to be honest though if you are buidling the SQL string then there is no reason for the SQL to be invalid. just make sure to check and sanitize all the variables you wan't to place inside the query (e.g. searching for name or selecting on id, etc)