 Sql Syntax Error [corrected], apostrophes missing |
|
|
|
|
  |
 Feb 17 2008, 11:17 PM
Post
#1
|
|
|
Advanced Member  Group: [HOSTED] Posts: 175 Joined: 19-January 08 From: Zagreb/Croatia Member No.: 27,735  |
QUOTE #1054 - Unknown column 'Eggie' in 'where clause' i get that error when i type this in MYSQL CODE select bike from members where username=Eggie i have column bike,members and username... and i have information in every of those columns... but why does it say that there is no COLUMN because i said i want info from row where column 'username' is 'Eggie' btw-YAY..my 101 post EDIT:sorry...i just solved it i forgot to put apostrophes CODE select bike from members where username='Eggie'
This post has been edited by yordan: Feb 18 2008, 10:14 AM |
 |
 
|
|
Feb 18 2008, 12:22 AM
Post
#2
|
|
|
Premium Member Group: [HOSTED] Posts: 495 Joined: 5-November 06 Member No.: 17,016 |
Well, this is always something a lot of ppl miss easily. Because the error "Unknown column" is quite misleading in this case. Anyway, it's good that you found out yourself.
|
|
|
|
|
Feb 18 2008, 10:15 AM
Post
#3
|
|
|
Way Out Of Control - You need a life :)  Group: [MODERATOR] Posts: 2,042 Joined: 16-August 05 Member No.: 7,896 |
QUOTE sorry...i just solved it i forgot to put apostrophes congrats for the self-repairing. I slightly touched the topic title in order to make it reflect the facts. |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 11th October 2008 - 06:39 AM |