Jump to content
ameliabob

DELETE FROM

Recommended Posts

I am trying to execute the following code

	            $qry = "DELETE FROM holdings WHERE 'rowId' = '".$row."'";
echo("alertAhead of delete.  ".$qry);
            $result= mysqli_query($cxn,$qry)or die("FinishExit Delete failed. ".mysqli_error($cxn)."   *** Qry was ".$qry);
	

the $qry variable when filled out is    DELETE FROM holdings WHERE 'rowId' = '9'

but the row is still in the database when I look at it with phpAdmin  and the die was not executed.

If I run  a query "select from holdings where rowId = '9' it is still there.

I have tried using a fictitious name in the delete and the die does work for that

Where should I look from here?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...