Jump to content


Photo

Unknown column error


  • Please log in to reply
1 reply to this topic

#1 cturner

cturner
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • LocationMy computer

Posted 25 October 2006 - 01:23 AM

I am getting this error when I test the following code: "Unknown column 'username' in 'where clause'". Can someone please tell me why and how I can fix it? Thanks in advance.

require "config2.php";
$username = mysql_real_escape_string($_GET['username']);

$copyrow = "SELECT * FROM `users` WHERE `username` = '$username'";

$result = mysql_query($copyrow) or die (mysql_error());

while($row = mysql_fetch_array($result)) {
	$password = $row['password'];
	$email = $row['email'];
	$ip = $row['ip'];
	$insert = "INSERT INTO `banned_users` (id, username, password, email, ip) VALUES (0, $username, $password, $email, $ip)";
}

if (mysql_num_rows() == 1) {
	print '<p><br /><br />The user has been deleted. <a href=ban_a_user.php>Click here</a> to continue.</p>';
} else {
	print "<p>Could not insert data because: <b>" . mysql_error() . "</b>. The query was $copyrow.</p>";
}
mysql_close();


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 October 2006 - 05:18 PM

That column doesn't seem to exist... post your table structure.  Also, you shouldn't pass a zero value for the id field in your INSERT statement; just leave the column out entirely.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users