How Do I Do This?

mart

How do I remove a row from a table based on a variable. The database has three tables. Depending on the variable, I would like for the php script to select the proper table and delete the the entire row.

This is what I did, but I get a syntax error:

<?php
$dbHost = "localhost";
$dbUser = "";
$dbPass = "";
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
$dbName = "players";
$db = mysql_select_db($dbName, $link) or die("couldn't select database");

$status = $_POST["status"];
$userid = $_POST["userid"];
    if ($status = "successful");		
	{
	 $query = "DROP FROM  players  WHERE userid = $userid";
     mysql_query($query,$link)or die(mysql_error());
}

the tables are: football, soccer, baseball.

Based on the received variable the script should be able to decide which table to delete from according to the $userid.

I am rahter new at this. I have a book, but unfortunately it does not answer questions. 🙁

Please help if you can.

devinemke

you want to use DELETE, not DROP

anoopabose

$query = "DROP FROM players WHERE userid = $userid";
if u want to delete a particular row use delete query.
ur query will delete entire table

mart

Thanks for you replies.

The problem is that I would like for the script to delete a row from one of three tables on the database depending on the values passed by the $userid

When I execute the script the way I had it, it tells me there is no such table in my database.

I there a way I could make the script pick the right table based on the $userid value with the information and delete the row where the info is stored?

devinemke

it sounds like there are three dynamic variables that you need to do your delete:

table name
field name
field value

pass them all to your script:

$sql = "DELETE FROM $table WHERE $field = $value";