Eggie
Feb 17 2008, 11:17 PM
| | 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' |
Reply
faulty.lee
Feb 18 2008, 12:22 AM
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.
Reply
yordan
Feb 18 2008, 10:15 AM
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.
Reply
Recent Queries:--
mysql syntax error with apostrophe - 100.03 hr back. (1)
-
itunes error code 609 - 390.35 hr back. (1)
-
sql syntax error - 441.41 hr back. (2)
-
sql syntax error winxp - 496.57 hr back. (1)
Similar Topics
Keywords : sql, syntax, error, corrected, apostrophes, missing
- I Have An Error With My Mysql Connection
mysql connection error (7)
Lost Connection To Mysql ,..., System Error: 111 In
(3) While I was trying to connect to my database or even create one using PhP mySQL I was given the
followoing error: Lost connection to MySQL server at 'reading initial communication
packet', system error: 111 in Has somebody encontered a similar report? I have my database
created using the cpanel together with a user name and password. I wonder if it is a server issue?
What can you do if you have not access to the configuration files?....
Need Syntax Help With MySQL And PHP
(8) I've been working on this for hours now which is really embarrasing really considering I've
got it to work perfectly in the past but I cant find the script I used then /sad.gif"
style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> Here is the script im working
on: QUOTE 1] mysql_connect("localhost", "root") or die( "Unable to connect to database"); 2]
echo "connected \n "; 3] mysql_select_db("users") or die("Unable to select database"); 4]
echo "selected "; 5] $query = "SELECT pass FROM 'login' WHERE name = 'chri....
New MySQL Server & Blank Fields Problem With Jsp
empty fields and data trancation error (0) New mysql server doesn’t take blank field through JSP code. If you write this code in jsp it will
show error. String sqlInsertDateIntoTable = “insert into TableName values( “”,
‘”+request.getParameter(“inputFieldName”)+”’,’”+request.getParameter(“inputFieldName2”)+”’,’’)”;
stm.executeUpdate(sqlInsertDateIntoTable); %> This code shows error , But in old alpha version of
mysql allow the blank field for autoincreaments. Error shows of “Data truncation“ This can be
easily remove by just write or add or table values in your query e.g String
sqlInsertDateIntoTable = ....
Problems With A Database Table & PHP Syntax
(21) Ok, because I am feeling dangerous and ready to move to the next level, I wrote a simple "page
generator" script for my website for several reasons: 1. I hate updating 20+ pages by hand just for
ONE little template change 2. I'm expanding my PHP & MySQL knowledge... Here is an error I get
on the page that is supposed to submit contents to the database: Parse error: parse error,
unexpected T_VARIABLE in /home/coco563/public_html/beta/make_page/make_page.php on line 11 Now, on
make_page.php, line 11 & 12 (where I feel the problem) is the following: CODE $sql....
Forum SQL Error
(3) Hello everyone! Well anyway, i've just tried to go to my site narutoglobal.astahost.com and
this comes up: QUOTE mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn,
m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop,
m.view_img, m.auto_track, m.mod_posts, m.language, m.skin, m.new_msg,
m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m....
Need Help On SQL Syntax
(2) How I make a query in SQL Server using a field of the type date? Example: SELECT * FROM Customer
WHERE Birth = ' 01/01/1982 ' I must use quotes marks same, or exists some another separator
for the field of the type date?....
phpMyAdmin-MySQL Error #1251:client Authentication
Stupid error (6) After I installed phpMyAdmin and tried logging in with the root password, I get this : #1251 -
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I already installed mySQL administrator and enabled old passwords. Any help would be
appreciated. Oh yeah I have : mySQL version 4.1.11-nt mySQL client 5.04 Apache 2.0.54 PHP 4.3.11
phpMyAdmin 2.6.1-pl3....
MySQL: Help Needed With MySQL_fetch_array() Error
help needed (7) I have my site up and running, it it written in php but the problem im getting is the mysql database
the warning is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/mrogers/public_html/config.php on line 47 but on line 47 it shows this:
$email = mysql_fetch_array($adminemail); any one help on this + my site wont connect to
my database. I have feeled out all the requirements that has asked and i know its write. All help
would be apreciated as i would like my site fully functional by next week. /smile.gif' bord....
Help Needed With MySQL_fetch-array() Error
(3) databasing is quiet hard to learn but im starting to get the hang of it. on my home page i have a
few errors like this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/mrogers/public_html/html/nav.php on line 80 i have checked whats on line 80 and
this is what i ended up with $row = mysql_fetch_array($sql); but it does not look like
anything is wrong and i kind of do not under stand the mysql witch i am learning at the moment, but
any one know what the problem is please tell me. need any more info like the whol....
Error In Installing MySQL Server
MySQL server cannot be started (6) I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
essential one) for win XP Then I install the new version after the old version was uninstalled.
After the installation process, Instance Configurator comes up to help for the configuration. But an
error occured when it try to start the MySQL service. Error messageis "cannot create windows
service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
Error In MySQL ?
(2) This message was in PHPMyAdmin! "The additional Features for working with linked Tables have
been deactivated. PMA Database ... not OK General relation features Disabled" Can anyone give me a
hint to what this means? Everything seems to be working just fine. All my tables are errorfree and I
haven't got a clue! But I'm not comfortable with having an error /wink.gif' border='0'
style='vertical-align:middle' alt='wink.gif' /> ....
No Record Found Error
(2) I am trying to run the following asp function:
code:-------------------------------------------------------------------------------- Private
Function GetAbs(dThisDate, lPartID) sql_abs = "SELECT AbsCode FROM Absence WHERE AbsDate = '" &
dThisDate & "' AND PartID = " & lPartID Set rs_abs = conn.Execute(sql_abs) GetAbs =
rs_abs(0).Value Set rs_abs = Nothing End Function
-------------------------------------------------------------------------------- It works fine if
it finds a record but returns an error if it doesn't. How can I avoid this error? Thank....
Looking for sql, syntax, error, corrected, apostrophes, missing
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for sql, syntax, error, corrected, apostrophes, missing
|
advertisement
|
|
