sort by date, title in PHP

[kilbey1]

I would like to sort the Jobs postings found on this site by date posted, and by title. I would provide a link allowing them to view it based on whatever they chose.

The jobs are currently in a database, and are currently being pulled in by PHP code, all wedged in layers to allow for scrollable content.

1. How would I accomplish a 'sort by'
   and
2. Would this affect my layering?

Here's the code used to pull in jobs for info:

<?php

$sql = "select * from wowjobs ORDER BY date_added DESC";
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());

while($row=mysql_fetch_array($result)) {
?>
                    <div align="left" style="text-align:left; font-size:11px"><img src="/images/arrows/arrow_red.gif" alt="Red Arrow">&nbsp;<b> <?php echo trim($row['Title']); ?></b>, <br>
                        <?php echo $row['Location']; ?>. <br>
  Duration: <?php echo $row['Duration']; ?>. <BR>
  					Posted: 
					<?php 
					$date_added = $row['date_added']; 
					$date = date("M d, Y", strtotime($date_added));
					echo $date;
					?>
  					</div>
                    <div align="right"><a class="jobs" href="careers/oppr.php?goto=details&id=<?php echo $row['id']; ?>"><b>More</b></a></div>
                    <?
}
?>

[bodzan]

I would check if there is an variable named $_GET['what'] or whatever in which I would pass the parameters that would allow me to sort my results by. Like:

$sql = "select * from wowjobs"; 
if(isset($_GET['what'])){
$sql .= " ORDER BY $_GET[what]";
}

Then, I would make links like:

echo "<a href=\"name_of_the_page.php?what=Title\">".trim($row['Title'])."</a>";

and

echo "<a href=\"name_of_the_page.php?what=date_added\">".$date."</a>";

and take it from there...

As for #2 I can't see the reason to mess up your layering but I'm not sure of it...

Just one more point: this code would make sorting by ASC by default. If you need DESC just add it to the $sql...

[Roger_Ramjet]

Must say I find it funny that a company advertising itself as "An established Global Solutions Provider with strength is Web, Legacy and Client-Server ..." does not know how to fashion a simple ORDER BY clause in basic SQL? Do your clients know this? 😃

[kilbey1]

LOL! Oh, I know how to fashion an order by clause fine; I just wasn't entirely sure whether to put it in my jobs code or on the link code itself. But what bodzan posted makes perfect sense, and I admit to feeling a bit stupid about it. 🙂

[godwheel]

Then again, you probably didn't write that copy 😛