a simple query

[Anon]

I have a query that goes :
SELECT * from $table where category='$category' order by date desc limit 0,10

When it run, mysql came with an error. Can someone please help?

[ace21]

What was the error and we need to see more code than just the one line.

Ace21

[Anon]

Why do you use $table and '$category'. The correct syntax seems to be SELECT * FROM TABLE where category=$category;

[Anon]

I have $table because I have it as a variable. More of the code will read
$table=poll;

$query = "SELECT * from $table where category='$category' order by date desc ";

$result = mysql_db_query($database, $query, $connection) or die
("Could not execute query: $query." . mysql_error());

$total_records = mysql_num_rows($result); // output number of rows in table
$pages = ceil($total_records / $rows_per_page); // rounds up 1 page

mysql_free_result($result);
if (!isset($screen))
$screen=0;

$start = $screen * $rows_per_page;
$sql .= "LIMIT $start, $rows_per_page";
$result=mysql_db_query($database, $sql, $connection) or die
("Could not execute query: $query. " . mysql_error());

And my error message is :
Could not execute query: SELECT * from data where category='PHP' order by date desc . You have an error in your SQL syntax near 'LIMIT 0, 10' at line 1

Can you please help? I know my query isn't correct but I don't know how to fix it. thanks