Pagination order by desc

[conan318]

i am using the pagination tutorial from this website and i cant get order by desc to work with it

thanks

$sql = "SELECT * FROM cvisinko_db.gallery JOIN cvisinko_db.users ON cvisinko_db.users.username = gallery.username WHERE  gallery.username=users.username  ORDER BY 'id' DESC LIMIT $offset, $rowsperpage ";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

[MasterACE14]

$sql = "SELECT * FROM cvisinko_db.gallery JOIN cvisinko_db.users ON cvisinko_db.users.username = gallery.username WHERE  gallery.username=users.username  ORDER BY `id` DESC LIMIT $offset, $rowsperpage ";

 

`id` as opposed to 'id'

[conan318]

just tryed your line and got  Fatal error: SQL

 

$sql = "SELECT * FROM cvisinko_db.gallery JOIN cvisinko_db.users ON cvisinko_db.users.username = gallery.username WHERE  gallery.username=users.username  ORDER BY `id` DESC LIMIT $offset, $rowsperpage ";

 

 

[MasterACE14]

can you change this...

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

to this temporarily so we can debug it...

$result = mysql_query($sql, $conn) or die(mysql_error());

[conan318]

ok changed it. no errors but not displaying in reverse order

[conan318]

sorry

Column 'id' in order clause is ambiguous

 

so then i tryed this.

$sql = "SELECT * FROM cvisinko_db.gallery JOIN cvisinko_db.users ON cvisinko_db.users.username = gallery.username WHERE  gallery.username=users.username  ORDER BY'gallery.id' DESC LIMIT $offset, $rowsperpage ";
$result = mysql_query($sql, $conn) or die(mysql_error());

 

sorry thought it was working but i was refreshed the wrong page lol

 

thanks guys