cant delete rows in MySQL!!!

[Anon]

hi there,

i dont know, whats wrong with this code, but it just wont delete the entry in my db!
I must say, that the variable is working right and that the line works in mysql, but not in this mysql_query.
Whats wrogn with this code?

$server = "localhost";
$user_db = "root";
$pass_db = "";
$conn = mysql_connect($server, $user_db, $pass_db);
if(!$conn) {
echo "<B>Sorry, a database error just occured. Please reload this page.</B>";
exit;
}
$sql = "DELETE FROM links WHERE id=$deleteme";
$result = mysql_query($sql,$conn);
mysql_close($conn);

thx for ur help,

so long,

Duncan McLord

[Anon]

just a thought while i was passing , but shouldn't it be
$sql = "DELETE * FROM links WHERE id=$deleteme";

[Anon]

nope...

just tried it... and i think its even not case sensitive... and it didnt work, 2!

hm...
i mean, strange is, that it works in mysql-prompt, but not as an mysql_query!

...at least for me here 😉

thx anyway,

Duncan McLord

[Anon]

DOH!

...i just forgot to tell it, which db to use!!!

$select = mysql_select_db("db",$conn);

well, thx anyway...

so long,

Duncan McLord