inserting and deleting rows

[skdzines]

how do I do an insert and a delete of a table?

I tried doing the following but it doesn't seem to work:

<?
$dbh=mysql_connect ("localhost", "whatnott_scott", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("whatnott_customer");


$insert_order=mysql_query("INSERT INTO `customer_info` ( `ID` , `domain` , `first_name` , `last_name` , `address` , `apt` , `city` , `state` , `zip` , `country` , `phone` , `email` , `package` , `cycle` , `startdate` , `status` , `comments` ) 
VALUES ('$orderID', '$domain', '$firstName', '$lastName', '$addr', '$apt' , '$city', '$state', '$zip', '$country', '$phone', '$email', '$package', '$cycle', '$date', '$status', '$comments' ");

?>

Is this correct? If so, maybe it just isn't passing the values.

Thanks

[olaf]

Hi, your Insert statement looks good, but where is your delete statement?

[skdzines]

I don't have a delete statement yet. I was wondering if someone could show me how.

Thanks

[olaf]

Just:

mysql_query("DELETE FROM table WHERE id = yourID");

read something on www.mysql.com