Need help with a delete statement

[dwilson]

I'm new to PHP and need help with a delete sql statement. What I'm trying to do is I have a page with a user name and id number. When they click yes to delete the user I want to delete that user from the table as well as everthing else tied to that user in another table. The two tables can be linked by user id number

[SeaBiscuit]

Looks like you are really in need of SQL statment?

something like:

DELETE FROM People WHERE LName='Smith'

then PHP would execute the sql statement on the sql server directly....

so the only real thing you would need php to do is to identify the "name" of the user to delete.... and then piece together the statment so ALL that names info is removed....

---

$connection = mysql_connect("host","user","password") or
die("can't connect");
$db = mysql_select_db("dbname") or die("can't connect to db");
$sql = "UPDATE tablename SET custname='$custname'";
$result = mysql_query($sql) or die("couldn't execute query");

---

sound like what your looking for?

Hope that helps...

Sea