Unknown column '' in 'where clause' error

Question

I'm making a website so once your logged in it goes to your profile but once you log in it gives me this error. Unknown column 'tom' in 'where clause' Tom is the username. it don't tell me which line but im pretty sure its this one.

$result =  queryMysql("SELECT * FROM profiles WHERE user=`$user`");

quertyMysql is defined in another file.

function queryMysql($query)
{
    global $connection;
    $result = $connection->query($query);
    if (!$result) die($connection->error);
    return $result;
}

is this enough code for anyone to tell me whats doing wrong?

http://dev.mysql.com/doc/refman/5.6/en/string-literals.html – CBroe Oct 19 '14 at 17:25 — CBroe, Oct 19 '14 at 17:25

Etixpp · Answer 1 · 2014-10-19T17:30:29.640

0

Do the following

echo "SELECT * FROM profiles WHERE user=`$user`";

and you will see immediately whats wrong.

probably you should use

 "SELECT * FROM profiles WHERE user='$user'"

you cant use backticks for a parameter, only for table and column names

edited Oct 19 '14 at 17:30

answered Oct 19 '14 at 17:27

Etixpp

320
2
11

There is no need to place `.` in your query like that – SuperDJ Oct 19 '14 at 17:30
ye it was a paste error ~~ – Etixpp Oct 19 '14 at 17:30

score 0 · Answer 2 · answered Oct 19 '14 at 17:28

0

Please change the query with this one :

$result =  queryMysql("SELECT * FROM profiles WHERE user='".$user."'");

answered Oct 19 '14 at 17:28

Nitesh Singh

328
3
13

Unknown column '' in 'where clause' error

2 Answers2