delete statement in mysql

Anon

Hi every one!
I am getting sintax error while delete the from mysql.
ERROR is:

Error: You have an error in your SQL syntax near 'name,salary FROM employee WHERE name='Bobby' ' at line 1

Please check my code:

<body>
<?php
mysql_pconnect("localhost","gopi","test");
mysql_select_db ("gopi");
$name="Bobby";
$query = "DELETE name,salary FROM employee WHERE(name='$name')";
mysql_query($query);
$result = mysql_query($query);
if ($result) {
echo "Worked";
}
else {
echo("<P>Error: " .
mysql_error() . "</P>");
}
?>
</body>

Leela

Anon

you can't delete specific columns.

syntax for delete is

delete from table_nm where clause;

RTFM

doss_

to delete columns use ALTER TABLE (look on mysql.com for specifics)