Weird error!

Sharif

I keep getting a:

Unknown column 'authorid' in field list...

That column DOES exist!

nemonoman

post your code, my friend.

Frederick

if you use like the following in your query, it interprets the variable as a fieldname and not a variable and will get an unknown.

WHERE filedname = ".$variable."

Sharif

Here is my code btw:

//A little sql magic...
$sql = "SELECT ";
$sql.= "id, authorid, username ";
$sql.= "FROM ";
$sql.= "members ";
$sql.= "WHERE ";
$sql.= "username = '$username' AND password = '$password'";
$query = mysql_query($sql);

I can't figure it out...

mourisj

What about your table structure .... ??

Sharif

CREATE TABLE members (
id int(11) NOT NULL auto_increment,
authorid int(11) NOT NULL default '0',
username varchar(32) NOT NULL default '',
password varchar(32) NOT NULL default '',
publishing_name text NOT NULL,
email text NOT NULL,
message_date date NOT NULL default '0000-00-00',
message text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM PACK_KEYS=0;

Frederick

Why are you breaking up your query?

$sql = mysql_query("SELECT * FROM members 
WHERE username = '$username' 
AND password = '$password'
") or die (mysql_error());
if (mysql_num_rows($sql)) {
    $row = mysql_fetch_array($sql);
} else {
     // No Go
}

TheDefender

Sometimes, I have noticed that case sensitivity can come into play... In other words, if your fieldname is Authorid and you try to query authorid, the query will fail. Now, the thing is this: phpMyAdmin will not show you the case, and will always show it all lower case, so it can be easily overlooked. Rename your table in phpMyAdmin and be sure to use all lower case. Also, if you query * as Frederick suggests, can you later echo the authorid field's value?