It's Me Again ...

[mart]

Can someone please help me send a query to mysql to drop a row from a table in a database based on the data in a paticular column?

The database has three tables . I would like for the script to find the paticular data and drop that whole row from the table. What is the proper sintax?

$query = "DROP row FROM database.* Where data is x";

It sounds like it shoud be simple, but this is my third day as a programmer 🙁 . I just picked up a book and started over the weekend. I don't know the language that well.

Mart.

Thanks in advance.

[Drakla]

Use more sensible thread titles and maybe somebody will help you.

[flientje]

<?
//connection
$connection=mysql_connect("localhost", "user", "password");

//selection
mysql_select_db("table", $connection) or die('Could not select table to delete);

//do query on db
mysql_query("DELETE FROM table WHERE id = 1") or
die('Could not delete.');
?>

grz Flientje

hope this helps..