simple DELETE won't work

Anon

Not sure whats happening with me tonite but I can't seem to delete from a mysql database. The script doesn't throw any errors and I can't see anything wrong......theres no problems with permissions or anything like that.

Perhaps someone else can see the problem which is no doubt right in front of me...

<?php

$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "hands_off";

$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("hands_off",$db);

if($add)
//we are adding
{
mysql_query("INSERT INTO songlist (artist,title) VALUES ('$artist','$title')");
}

if($delete)
//we are deleting
{
mysql_query("DELETE * from songlist WHERE title = '$title'");
}

if($update)
//we are updating
{
mysql_query("UPDATE songlist SET title='$title',artist='$artist' WHERE title='$old_title'");
}

//now get results
$query = mysql_query("SELECT * FROM songlist");
while($row = mysql_fetch_row($query))
{
//get columns
$artist = $row[0];
$title = $row[1];

print ("<tr>\n<td>$title</td>\n");
print ("<td><a href='edit_song.php3?title=$title'>Edit</a></td>\n");
print ("<td><a href='delete_song.php3?title=$title'>Delete</a></td>\n</tr>");
}

Any ideas....?

regards,
scott d~

Anon

Im not sure
(cause I´ve never used MySQL)
but in Sybase, I use the drop command
to shoot:
drop * from blablabla
instead of delete.

Tell me if it works.
/Chess

Anon

i think you have the format of DELETE function wrong.

normally its:

DELETE FROM tablename WHERE id='id_number'

try above. i think you have DELETE and the () is causing some errors.

cheers!

Anon

seams fine to me

Anon

Thats if you want to drop a whole table or db, not a row

Anon

ah K