glenelkins Posted March 1, 2006 Share Posted March 1, 2006 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?? Quote Link to comment https://forums.phpfreaks.com/topic/3830-problem-deleteing-record/ Share on other sites More sharing options...
XenoPhage Posted March 1, 2006 Share Posted March 1, 2006 The search term, admin, needs to be in quotes. Quote Link to comment https://forums.phpfreaks.com/topic/3830-problem-deleteing-record/#findComment-13291 Share on other sites More sharing options...
glenelkins Posted March 1, 2006 Author Share Posted March 1, 2006 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 Link to comment https://forums.phpfreaks.com/topic/3830-problem-deleteing-record/#findComment-13293 Share on other sites More sharing options...
XenoPhage Posted March 1, 2006 Share Posted March 1, 2006 [!--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. Quote Link to comment https://forums.phpfreaks.com/topic/3830-problem-deleteing-record/#findComment-13300 Share on other sites More sharing options...
glenelkins Posted March 1, 2006 Author Share Posted March 1, 2006 its ok now thanks. cant remember why i had a problem with it Quote Link to comment https://forums.phpfreaks.com/topic/3830-problem-deleteing-record/#findComment-13312 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.