deleting rows

[Anon]

hi all
what i basically want to do it delete a row from a mySQL database table using php...
what im thinking is using "mysql_query ( <insert code to delete a row > );"
but i just want to make sure ^'

and possibly is there anyway i could use php to actually delete a file in general (eg .html, .zip, etc)

thankyou ^_

[lawnmowerman]

You are correct. To delete a row (or rows) from a MySQL database table, use:

mysql_query( "DELETE FROM MyTable WHERE field=value" );

All fields matching the WHERE (or ALL fields if the WHERE clause is missing) will be deleted.

To delete a file from the filesystem, look into the unlink() function.

-Rich