Unknown column mysql error :(

[EcLip_e]

i am getting this error in my browser:

Unknown column 'playernews' in 'where clause'

and have been banging my head against the wall trying to figure this out. here is my sql statement:

mysql_select_db($database_connRUBIX, $connRUBIX);
$query_rsComments = sprintf("SELECT * FROM comments WHERE link = " . $_GET['view'] . " AND category = " . $_GET['page']);
$rsComments = mysql_query($query_rsComments, $connRUBIX) or die(mysql_error());
$row_rsComments = mysql_fetch_assoc($rsComments);
$totalRows_rsComments = mysql_num_rows($rsComments);

thnx,

[swr]

In SQL, you need to enclose strings in single-quotes. Otherwise it'll think you mean a column name.

Also, you don't need to use sprintf in that case, just use a simple assignment. But if you want to use sprintf...

$query_rsComments = sprintf("SELECT * FROM comments WHERE link = '%s' AND category = '%s'", mysql_escape_string($GET['view']), mysql_escape_string($GET['page']));

[TomD]

Try

$query_rsComments = "SELECT * FROM comments WHERE link = $_GET['view'] AND category = $_GET['page'];"

or

$view = $_GET['view'];
$page = $_GET['page'];
$query_rsComments = "SELECT * FROM comments WHERE link = $view AND category = $page;"

If columns link and catagory are type CHAR then the query would be

$view = $_GET['view'];
$page = $_GET['page'];
$query_rsComments = "SELECT * FROM comments WHERE link = '$view' AND category = '$page'";