New topic ends up on the last page...

[Gubbins]

Hi,

 

This piece on sql ends up putting a new topic on the last page, is there anychance it can be altered so that a new topic is on the first page?

 

$query = mysql_query("SELECT * FROM topics WHERE forum = '$forum' ORDER BY `s` DESC, lastreply DESC LIMIT $forum_look , $forum_count")or die("Couldn't get topics:" .mysql_error());
$num = mysql_num_rows($query);

[aeroswat]

Hi,

 

This piece on sql ends up putting a new topic on the last page, is there anychance it can be altered so that a new topic is on the first page?

 

$query = mysql_query("SELECT * FROM topics WHERE forum = '$forum' ORDER BY `s` DESC, lastreply DESC LIMIT $forum_look , $forum_count")or die("Couldn't get topics:" .mysql_error());
$num = mysql_num_rows($query);

 

Not very descriptive what is s? and what values does lastreply hold?

[merylvingien]

ORDER BY ASC

[Gubbins]

ORDER BY ASC

 

Spot on mate, cheers