Jump to content

Archived

This topic is now archived and is closed to further replies.

glenelkins

problem deleteing record

Recommended Posts

i use the following to delete the admin record from a user accounts database:

$sql = "DELETE FROM accounts WHERE username=admin";

but it brings back this error: Unknown column 'admin' in 'where clause'

whats the problem??

Share this post


Link to post
Share on other sites
you mean like

$sql = "DELETE FROM accounts WHERE username="admin""; ??? this causes error

$sql = "DELETE FROM accounts WHERE username=\"admin\""; ?? causes error

$sql = "DELETE FROM accounts WHERE username='admin'"; ?? causes error


Share this post


Link to post
Share on other sites
[!--quoteo(post=350624:date=Mar 1 2006, 09:55 AM:name=glenelkins)--][div class=\'quotetop\']QUOTE(glenelkins @ Mar 1 2006, 09:55 AM) [snapback]350624[/snapback][/div][div class=\'quotemain\'][!--quotec--]
you mean like

$sql = "DELETE FROM accounts WHERE username="admin""; ??? this causes error

$sql = "DELETE FROM accounts WHERE username=\"admin\""; ?? causes error

$sql = "DELETE FROM accounts WHERE username='admin'"; ?? causes error
[/quote]

Well, the first one won't work. But the other 2 should. Please post the error you are getting.

Share this post


Link to post
Share on other sites
its ok now thanks. cant remember why i had a problem with it

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.