Whats Wrong With This Query?

[Hypersource]

Somethings wrong with the syntax of this:

 

$tokens=mysql_query("GET user_name FROM users WHERE user_name=$tik");

 

Help? error says:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GET user_name FROM users WHERE user_name=Admin' at line 1

 

 

 

Thanks in advance!

Edited November 25, 2012 by PFMaBiSmAd
removed wysiwyg formatting to fix micro font

[iarp]

SELECT not GET.

 

$tokens=mysql_query("GET SELECT user_name FROM users WHERE user_name=$tik");

Edited November 25, 2012 by iarp

[beyzad]

GET?

Edited November 25, 2012 by beyzad

[Hypersource]

Now I get

 

 

Unknown column '[whatevers int $tik variable]' in 'where clause

Edited November 25, 2012 by Hypersource

[iarp]

Is $tik quoted at any point before this query, otherwise it'll need single quotes.

$tokens = mysql_query("SELECT user_name FROM users  WHERE user_name = '$tik'");

[Hypersource]

Your right!