Delete row from database table

dsgf

Here is the issue:
I pass a $photo_id value in the URL and want to delete the row with that photo_id.

When I submit, I get the message I would hope to but the record is not deleted. Any ideas what I am doing wrong?
Thanks for any help!!

Here is the code:

################################ # # # # # # # # # # # # # # #

OPEN DATABASE CONNECTION

################################ # # # # # # # # # # # # # # #

$db = mysql_connect("xxxxx", "xxxxxxx", "xxxxxxxxxxx");
mysql_select_db("aft",$db);

################################ # # # # # # # # # # # # # # #

DELETE SPECIFIED ROW FROM TABLE

################################ # # # # # # # # # # # # # # #

$sql = "DELETE FROM photographs WHERE photo_id='$photo_id'";

$deleted="yes";

<?
if ($deleted=="yes") {print "$photo_id DATA DELETED, THANK YOU<br>";}

</body>
</html>

stolzyboy

the way you have $deleted it will be set to less no matter what, whether the query returns true or false, you aren't running your query

$sql = "DELETE FROM photographs WHERE photo_id='$photo_id';"; // not the added semicolon after photo_id
$result = mysql_query($sql) or die(mysql_error());

try that and let us know

dsgf

That worked like a charm. Thank you VERY MUCH!!!