2 questions about deleting records

[deepfrybonanza]

I have two newbie-type questions about deleting records. First of all, I tried to put together the following script but I can't get it to work. Any ideas what the problem is?

<?

$id=$_GET['id'];

$username="xxxxx";
$password="xxxxx";
$database="xxxxx";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$result = mysql_query("DELETE FROM play WHERE id='$ud_id'") or die(mysql_error());


echo $query;
echo "Record Deleted";
mysql_close();

?>

Secondly, is there a way to ask if the person is sure they want to delete the record and then have them click yes or no without writing a whole separate page? I see this often enough on the web that you would think it would be pretty easy.

Daniel

[theeper]

What error are you getting ?

If you want to ask the user "are you sure", you could use
JS.

[deepfrybonanza]

Okay, I got the delete part working (I mis-typed the variable in the query in case you were wondering), but what java script do I use to confirm the link? The scripts I know all require the actual URL you go to to be in the head of the document, and I don't know how to pass the variable to the head of the document. Actually, come to think of it I do know how to do that, but I have multiple queries on the same page, all of which need to access this script. Is there a confirmation script that resides wholly in the a tag?

[stolzyboy]

put this-------

<script language="JavaScript1.2">
function checker()
{
return confirm("Are you sure you want to delete this record?");
}
</script>

---------- in the head of your page

and make your submit button/link like this----------

<input type="submit" onclick="return checker();">