problem deleteing record

[glenelkins]

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??

[XenoPhage]

The search term, admin, needs to be in quotes.

[glenelkins]

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

[XenoPhage]

[!--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.

[glenelkins]

its ok now thanks. cant remember why i had a problem with it