Blog aflopend sorteren resulteert in Mysql error
Code (php)
1
2
2
$query_pag_data = "SELECT id,title,image from blog LIMIT $start, $per_page";
$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
Hiervan heb ik het volgende gemaakt maar dit resulteert in
Code (php)
1
MySql ErrorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY id DESC' at line 1
Code (php)
1
2
2
$query_pag_data = "SELECT id,title,image from blog LIMIT $start, $per_page ORDER BY 'blog'.'id' DESC";
$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
Iemand een idee wat hier fout gaat?
Code (php)
1
$query_pag_data = "SELECT id,title,image from blog ORDER BY id DESC LIMIT $start, $per_page";
