Entry Deleted

Anon

Below is code which is supposed to delete one row from the table.. But deletes the LOT??

Saved as delete.php

<?php

include("./include/dbconnect.php
if($delete = "delete")
{

mysql_query("delete from front_page where $d_row");

print "Entry Deleted";
}
else
{
print "Entry is not deleted";
print "<br><br>";
echo mysql_error();
}

There may be an obvious problem there .... However if there is not and is not easy to solve... There is a here is the form with which the action is posted from...

Saved as remove.php

$content = mysql_query("select * from front_page") or
die (mysql_error());

$num_rows = mysql_num_rows($content);
print "There are currently $num_rows news enteries";

while ($a_row = mysql_fetch_array($content))
{
?>

<form method=post action=delete.php name=delete>
<input type="hidden" value="<? echo $a_row[id] ?>" name="d_row">
<input type="submit" value="delete" name="delete"></form></td>
</tr>
<tr>
<td colspan="3" height="52" valign="top"><? echo $a_row[content] ?></td>
</tr>
<tr>
<td height="21" colspan="3" valign="top">Posted on: <? echo $a_row[date] ?></td>
</tr>
</table>

}
else
{
mysql_error();
}

I know there is some table code in there as well... but I need that code in there to have any layout problems picked at by you GURUS over there...

Keep on goin lads...

Code from you peeps has allways been helpful. Just i never type it right... LOL

Thanks

smarlowe

You realize that this statement has no real condition:

delete from front_page where $d_row

it should be

delete from front_page where rowid=$d_row

or something like that.

matto

at a glance:

mysql_query("delete from front_page where $d_row");

if $d_row holds an id number, the statement should be:
mysql_query("delete from front_page where id=$d_row");

(otherwise, mysql gets the statement

"delete from front_page where 15" (if $d_row == 15)

and I think it assumes 15 to mean "true" which remains true for all of the records ... this might be the cause for a lot of records disappearing.)

Anon

I tryed changing my code to below

mysql_query("delete from front_page where id=$d_row");

But however does not delete anything... just says it has?

Any help

Anon

it may help if you are able to see it...

http://podnet.no-ip.com/admin/main/main.php -- to insert information

http://podnet.no-ip.com/index.php -- to view information

http://podnet.no-ip.com/admin/main/remove.php -- to delete

Dont know if any of that can help analyse the problem

amcgrath

this doesnt look right: mysql_query("delete from front_page where $d_row");

maybe mysql_query("delete from front_page where some_column = $d_row");

Anon

Nope that didnt work?? not fair LOL

amcgrath

This is your code:

<?php

include("./include/dbconnect.php
if($delete = "delete")
{

mysql_query("delete from front_page where $d_row");

print "Entry Deleted";
}
else
{
print "Entry is not deleted";
print "<br><br>";
echo mysql_error();
}

if ($delete = "delete") should use == instead of = ....
As I said earlier, and Scott Marlow before me, you have no condition in your delete statement. Basically, you are saying delete everything. So, you need to identify the row you want to delete, hence where some_column = $your_value...

PS enter the correct name of your column instead of some_column....

Anon

Thanks All...

After looking more closley i noticed that the == was the problem and also the some_colmn (id) was a small part of it too.. as i didnt put in space where it should have been..

OK.. just quick one.. Reversing the ordre of which a database is viewed? any ideas?

amcgrath

select * from table order by field desc
select * from table order by field asc

Anon

Thanks!!

was easier than i thourght... i might be back another day for more help.. i need a break now