Invalid query: Unknown column 'referral_id' in 'field list'

Question

Help, This is the full error

SELECT id, Username, IP, SecureIP, AdminLevel, Helper, referral_id FROM accounts WHERE Username = 'test'Invalid query: Unknown column 'referral_id' in 'field list'

My code

$admquery = "SELECT `id`, `Username`, `IP`, `SecureIP`, `AdminLevel`, `Helper`, `referral_id` FROM `accounts` WHERE `Username` = '$myusername'";
$admincheckquery = mysql_query($admquery);

if (!$admincheckquery) {
    echo $admquery;
    die('Invalid query: ' . mysql_error());
}

$adminchk = mysql_fetch_array($admincheckquery);

HELP

Well, the error is self-explaining: `Unknown column 'referral_id'` , i.e. there's no column with that name in that table. — dnoeth, May 16 '15 at 21:28
Please read https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php — Michas, May 16 '15 at 21:29
please execute SELECT * FROM `accounts` and check the names of all columns. — Stéphane GRILLON, May 16 '15 at 21:33
@sgrillon or, better yet, execute a `SHOW CREATE TABLE accounts` and make note of the columns and their types. — David Hoelzer, May 16 '15 at 22:05
Downvoting for failing to even try to look at a search engine or read documentation first. — David Hoelzer, May 16 '15 at 22:05

score 0 · Answer 1 · answered May 16 '15 at 22:03

0

referral_id column doesn't exist in the accounts table.

answered May 16 '15 at 22:03

Jimeh

367
1
6
16

Invalid query: Unknown column 'referral_id' in 'field list'

1 Answers1