Re: re-order a sql result
| From: | Mikey | Date: | Mon, 18 Jul 2005 11:03:06 +0000 |
| Subject: | Re: re-order a sql result | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-218860@lists.php.net to get a copy of this message | ||
Ross wrote:
I have a query $query = "SELECT * FROM sheet1 WHERE '$filter' LIKE '$search_field%'" This prints out a table while ($row = @mysql_fetch_array($result, MYSQL_ASSOC)){ // this just fills the empty cells if ($row['fname']==""){ $row['fname']=" "; } if ($row['sname']==""){ $row['sname']=" "; } if ($row['organisation']==""){ $row['organisation']=" "; } ?><td class="right_line"><strong><a href="this_page.php?order=f_name&order=desc">Firstname</a></strong></td> HTH, Mikey<td width="71" class="right_line"> <?=$row['fname'];?> </td><td width="45" class="right_line"><?=$row['sname'];?></td> <td width="437" class="right_line"><?=$row['organisation'];?></td> <? if (!$row['email']==""){ ?> <td width="165" class="end_cell"> <div align="left"><a href="view_details.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">details</a> | <a href="edit.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">edit</a> | <a href="delete.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">delete</a> I <a href="mailto:<?=$row['email']; ?>">email</a></div></td> <? } else { ?> <td width="171" class="end_cell"> <div align="left"><a href="view_details.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">details</a> | <a href="edit.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">edit</a> | <a href="delete.php?id=<?=$row['id'];?>&sname=<?=$row['sname'];?>">delete</a> I <a href="mailto:<?=$row['email']; ?>">empty</a></div></td> <? } ?> </tr> <? } } ?> but I have the three headings at the top which I want to use to re-order the results alphabetically. So when I click on surname it will re-reorder them aphebetically (z-a) and when I click on it again it will reverse it (a-z) <td class="right_line"><strong>Firstname</a></strong></td> <td class="right_line"><strong>Surname</strong></td> <td class="right_line"><strong>Organisation</strong></td> hope this is clear. Ross Well, your question is a little vague, but to order the mySQL query you should use the ORDER BY clause in your query. You would then have to use a link to re-submit your page with the order by criteria passed in. e.g.