Jump to content

Archived

This topic is now archived and is closed to further replies.

cturner

Unknown column error

Recommended Posts

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.

[code]
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();
[/code]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.