Unknown column 'user_id' in 'field list'

[dan]

ok in the process of developing a new site in replace of my old site(on the same host and mysql sever if that helps any) I got "Unknown column 'user_id' in 'field list'" as a database error message for this code:

if ($a AND $b AND $c AND $d AND $e AND $f) {
$query = "SELECT user_id FROM user_profile WHERE user_name = '$HTTP_POST_VARS[user_name]'"; //it won't go past this point!!!!!!!!//
$db_query= @mysql_query($query) or die (mysql_error());
$row = @mysql_fetch_array($db_query) or die (mysql_error());
if ($row){
$message = "That username is already taken. Please select another.
";
} else {
$query2 = "INSERT INTO user_profile (username, password, permission, first_name, last_name, email, site, first_login) VALUES ('$HTTP_POST_VARS[user_name]', '$password', '!', '$HTTP_POST_VARS[first_name]', '$HTTP_POST_VARS[last_name]', '$HTTP_POST_VARS[email]', '$HTTP_POST_VARS[website]', '$timestamp')";
$query_db2 = mysql_query($query2) or die (mysql_error());

now, I'm 100% sure this feild exists, and 100% sure i'm connected to the database
any help would be much appreciated, thank you

[Xnuiem]

That error means only one thing, the field is not in that table.

Make sure the field is there, make sure everything is spelled right.

Also, $HTTP_POST_VARS is deprecated, use $_POST

[dan]

phpMyAdmin is telling me those fileds exist and i just copied and pasted them into my code.

also the following code produces "Unknown column 'entree_id' in 'order clause'" as an error:

default:
$sql = "SELECT * FROM journal_entree ORDER BY entree_id DESC LIMIT $start, 5 ";
$query = mysql_query($sql) or die(mysql_error());
$row =mysql_fetch_array($query);
while($row){
$entree[id] = $row[entree_id];
$entree[user_id] = $row[user_id];
$entree[subject] = $row[subject];
$entree[time] = $row[time];
$entree[entree] = $row[entree];
$entree[ip] = $row[ip];
$entree[browser] = $row[browser];
$sql2 = "SELECT username FROM user_profile WHERE user_id = $entree[user_id]";
$query2 = @mysql_query($sql2) or die(mysql_error());
$entree[name] = @mysql_fetch_array($query_db) or die(mysql_error());
}
return $entree;
break;
}

I've copied and pasted the fields into my code from phpMyAdmin as well. It seems like every mysql query I'm exicuting is returning these type of errors. Could it have anything to do with my configureation? Could it be that i have to many databases?I have 5 up right now.

[Xnuiem]

number of databases wont have anything to do with it.

You may not be connected to the correct database.

[dan]

this is how I connect to my database. I also copy and pasted the name of the data base from phpMyAdmin into $db_info[db].

//CONNECT TO DATABASE//
$db_connection = mysql_connect($db_info[host], $db_info[username], $db_info[password])
or die(mysql_error());
//SELECT DATABASE//
mysql_select_db ($db_info[db], $db_connection) or die (mysql_error());

I'm stummped!!!!

[satty_dey]

Please check that the field name user_id does not have a preceeding or trailing blank space, I experienced similar kind of issues and found that there was a trailing blank space

[dan]

YOU ARE THE BEST HUMAN IN THE FACE OF THIS EATH!!!!!!!!!!!!!!! DO YOU KNOW HOW MUCH TIME I SPENT ON THIS THING AND IT WAS A BLANK SPACE!!!!!!!!!!!!!! I LOVE YOU!!!!!!!!!!!! IF YOU WERE A WOMEN I"D MARRIE YOU ON THE SPOT!!!!!!!!!!!!!!!!!

[satty_dey]

Glad that it solved your problem, btw I'm a guy and I'm already married