[Resolved] Field Existance..

[warmasice]

newbie...

is there anyway to find if a record in a mysql table exists? if it does, i then want to carry out the following query....

DELETE FROM databse WHERE record = X

if X doesn't exist then i will ony echo a suitable message saying "not found".

Thanks in advance.

[zhabala]

You can just do:

DELETE FROM table WHERE any condition

then you can check mysql_affected_rows() if there is a zero, then no row was deleted otherwise it returns the number of deleted rows.

Or you can just do SELECT count(*) FROM table WHERE any condition. And the the statement will return the number of corresponding rows.

Zdenek

[warmasice]

ahh great job!

Thanks alot matey!