ROW WILL DELETE...

Anon

I'm trying to delete rows from a table but its not working. Here's the code:

$sql = "DELETE from students where ROWID='$rowid'";

$connection = mysql_connect("localhost","univrel","univrel") or die ("Couldn't connect to server.");

$db = mysql_select_db("univrel",$connection) or die ("Couldn't connect to database.");

$result = mysql_query($sql, $connection);

echo ("Record deleted for $name");

// If ($result == 0)
{
// echo ("ERROR: RECORD NOT DELETED!");

}
// else
{
// echo ("Record deleted!");
}

mysql_free_result($sql_result);

?>

The rowid i'm referencing is from the code below:

<h1>Student Records List</h1>

$sql = "SELECT * from students";

If ($name)
$sql .= "name like '%$name%' and ";
If ($email)
$sql .= "email like '%$email%' and ";
If ($password)
$sql .= "password like '%$password%' and ";
If ($department)
$sql .= "department like '%$department%' and ";

$connection = mysql_connect("localhost","univrel","univrel") or die ("Couldn't connect to server.");

$db = mysql_select_db("univrel",$connection) or die ("Couldn't connect to database.");

$sql_result = mysql_query($sql,$connection);

<table border=\"1\" cellspacing=\"5\" cellpadding=\"3\">
<tr>
<td align="center"><b>Name</b></td>
<td align="center"><b>Email Address</b></td>
<td align="center"><b>Password</b></td>
<td align="center"><b>Department</b></td>
<td align="center"><b>Modify/Delete</b></td>
</tr>

<?
while (($row = mysql_fetch_object($sql_result)))
{
printf("<tr>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td><a href=\"modify.php3?rowid=%s\"><I>Modify</I></a>|<a href=\"delete.php3?rowid=%s\"><I>Delete</I></a></td>
</tr>\n", $row->name, $row->email, $row->password, $row->department, $row->ROWID, $row->ROWID);
}
printf("</table>\n");

mysql_free_result($sql_result);

</form>
</center>
</body>

CAN YOU HELP ME PLEASE!!!

Anon

What I think is that you don't define 'WHERE' for:

$sql = "SELECT * from students";
If ($name)
$sql .= "name like '%$name%' and "...

You should have:
$sql = "SELECT * from students WHERE ";
If ($name)
$sql .= "name like '%$name%' and "...

That is what I see at the first glance. Or am I mistaking?

Anon

ROWID's are normally numeric. Without knowing your table structure it is hard to be certain, but I'd try the sql statement without the single quotes around the ROWID. Like........

$sql = "DELETE from students where ROWID=$rowid";

Anon

Hello,

Thanks for helping me. I tried all your tips but its still not working.

I believe i'm not understanding the rowid attribute. When you say normally numeric, where are you talking about in my code?

Here is my database structure.

Here are codes again.

<h1>Student Records List</h1>

$sql = "SELECT * from students";

$connection = mysql_connect("localhost","univrel","univrel") or die ("Couldn't connect to server.");

$db = mysql_select_db("univrel",$connection) or die ("Couldn't connect to database.");

$sql_result = mysql_query($sql,$connection);

mysql_free_result($sql_result);

</form>
</center>
</body>

$sql = "DELETE from students where ROWID=$rowid";

$connection = mysql_connect("localhost","univrel","univrel") or die ("Couldn't connect to server.");

$db = mysql_select_db("univrel",$connection) or die ("Couldn't connect to database.");

$result = mysql_query($sql, $connection);

echo ("Record deleted for $name");

// If ($result == 0)
{
// echo ("ERROR: RECORD NOT DELETED!");

}
// else
{
// echo ("Record deleted!");
}

Anon

Your table structure does not have a rowid column defined. The links in the code you are using attempt to pass in a rowid (something.php3?rowid=%s) to the subsequent programs. The rowid column is used within the database to establish a unique identifier for each row. That way you can have two or more students with the same name and still be able to modify or delete just their information.

Also, as Annchen had mentioned, your initial setting of the $sql variable needs to be changed to include the word WHERE (including the trailing space), like so.

$sql = "SELECT * from students WHERE ";

Hope all this helps.

Anon

Thanks for helping me understand!

Now how is it that when i hit delete, i receive no response:

TABLE:

+-------+------+-------+----------+------------+
| rowid | name | email | password | department |
+-------+------+-------+----------+------------+
| 1 | rob | rob | rob | rob |
| 2 | i | dont | know | nothing |
| 3 | how | about | this | one |
+-------+------+-------+----------+------------+

CODE:

$sql = "DELETE * from stud WHERE ROWID=$rowid";

$connection = mysql_connect("localhost","univrel","univrel") or die ("Couldn't connect to server.");

$db = mysql_select_db("univrel",$connection) or die ("Couldn't connect to database.");

$result = mysql_query($sql, $connection);

echo ("Record deleted for $name");

// If ($result == 0)
{
// echo ("ERROR: RECORD NOT DELETED!");

}
// else
{
// echo ("Record deleted!");
}

Anon

I've never used mysql, but in other sql languages you only get something back when you SELECT something from the database. SQL statements like an INSERT or UPDATE or DELETE do not normally return anything (except perhaps an error message).