[SOLVED] Deleting seperately.

[Bullet]

        <td class="TableArea"><div align="center"><a href='kill.php?delete=$buttock->id'>Delete</a></td>

Thats the link to delete the search.

 

PHP:

if (strip_tags($_GET['delete'])){

mysql_query("DELETE id FROM search WHERE id='$buttock->id'");

echo "You deleted the search.";

}

 

When I click on the link it says "You deleted the search." But it doesn't, help?

[Mchl]

DELETE FROM search WHERE id='$buttock->id'

 

http://dev.mysql.com/doc/refman/5.0/en/delete.html

[Bullet]

I found 1 problem:

 

        <td class="TableArea"><div align="center"><a href='kill.php?delete=<? echo"$buttock->id"; ?>'>Delete</a></td>

 

Now it shows what ID it is. But it still doesn't delete.

[budimir]

The problem is in your kill.php. Can you post that code?

[Bullet]

        <td class="TableArea"><div align="center"><a href='kill.php?delete=<? echo"$buttock->id"; ?>'>Delete</a></td>

That?

[Bullet]

Anyone?  ???

[Mchl]

Can you show us kill.php code?

[Bullet]

$s_query=mysql_query("SELECT * FROM search WHERE username='$username' ORDER by id DESC");

$numeros=mysql_num_rows($s_query);

 

if (strip_tags($_GET['delete'])){

mysql_query("DELETE FROM search WHERE id='$buttock->id'");

echo "You deleted the search.";

}

 

  <? while($buttock = mysql_fetch_object($s_query)){ ?>

 

        <td class="TableArea"><div align="center"><a href='kill.php?delete=<? echo"$buttock->id"; ?>'>Delete</a></td>

 

 

Not these are not together, I got the information which is linked to the deletion.

[Bullet]

I can't find a way, I'm sure you PHP coders have a diferent style which will work

[BlueSkyIS]

to help see the problem, echo your SQL statements:

 

$sql = "DELETE FROM search WHERE id='$buttock->id'";
echo "sql: $sql<BR>";
mysql_query($sql) or die(mysql_error());

[Bullet]

Now it says: sql: DELETE FROM search WHERE id=''

 

Doesn't say the ID even though when I hover over delete on the site it says the ID.

[BlueSkyIS]

what happens in the browser window may have little to nothing to do with what happens on the server. ignore what the button says. the point is that the id isn't set in the code where you expect it to be. the problem is that you are invoking $buttock before $buttock is created. $buttock is created here, but you use it before here:

 

while($buttock = mysql_fetch_object($s_query)){

 

[Bullet]

True, I thought about it before but didn't try it like an idiot, anyway, thanks I've fixed

[BlueSkyIS]

very good. you were doing things $buttock backwards.