dedelryNopVor
New Member
I have a database that has two fields: current, and previous. Here is the code:\[code\] <?$username="*****";$password="*****";$database="******";mysql_connect(localhost,$username,$password) or die("Unable to connect to server");mysql_select_db($database) or die( "Unable to select database");$query='SELECT * FROM tasks WHERE current=1 OR previous=1';$result=mysql_query($query);$num=mysql_num_rows($result); mysql_close();?>\[/code\]It then output it and manipulate it like this:\[code\]<div class="tasklist"> <div class="currentProject"> Current Project: </div><?$i=0;while ($i < $num) {$title=mysql_result($result,$i,"Title");$link=mysql_result($result,$i,"Weblink");$description=mysql_result($result,$i,"Description");$id=mysql_result($result,$i,"ID");$howto=mysql_result($result,$i,"howto");$blogpost=mysql_result($result,$i,"blogpost");$done=mysql_result($result,$i,"done");$current=mysql_result($result,$i,"current");$previous=mysql_result($result,$i,"previous");if ( $current == 1 ) { $current = "current";} else { $current = "";}if ( $previous == 1 ) { $previous = "previous";} else { $previous = "";}?> <div class="<? echo $done ?> task <? echo $id ?>" id="<? echo $current.$previous ?>"> <div class="titleWrapper"> <div class="title"> <a class="article" href="http://stackoverflow.com/questions/3795293/<? echo $link ?>"><? echo $title ?></a> </div> </div> </div><BR><?$i++;}echo "</div>";?>\[/code\]The problem is that since previous comes before current in the database, it outputs previous and then current.Question:How do I make sure to output \[code\]current\[/code\] first, and then \[code\]previous\[/code\]?