Suppress Database Error

[BulliM]

vB results an error, when I try to delete a non existing row. DELETE FROM same_table AS a WHERE EXISTS (SELECT * FROM same_table AS b...) or @ before are not working. Any idea how to supress this error?

[BulliM]

Will look at. Thank you so far.

[shka]

Sorry I read column, not row. What is the goal of your sql-statement.

[BulliM]

DELETE FROM database.table WHERE userid =$ LIMIT 1

So instead of updating, I prefer to delete and recreate this entry in this case, because I doesn't know, if this entry already is created.

[shka]

Delete all from table? Or is generation the condition "=$" your problem?

[BulliM]

Originally Posted by shka

Delete all from table? Or is generation the condition "=$" your problem?

Delete only and single row from table if exists. $ means e.g. 1 or 51 or an other variable userid. In this table I store some data, who needs to be refreshed in intervals - only if they exist.

[shka]

It is a question of your error handling style.
You can use "Select count(userId) as userCount from table where userId=$", check if >0 and then delete.
Or you can use directly "Delete form table where userId=$"

But in the same way of my first (deleted) answer - I advice using vBulletin-Api (if your table is in the vB-DB).
vB_dB_Query and the following classes (also for delete, insert, update) includes an property error for handling it