Table sorting with PHP/MySQL

From: Date: Tue, 30 May 2000 10:52:34 +0000
Subject: Table sorting with PHP/MySQL
Groups: php.general 
Request: Send a blank email to php-general+get-590@lists.php.net to get a copy of this message
Hi, I have a keywords table in MySQL that contains keywords. The format they currently get displayed in is : Tip Number Keyword
      1            insert
      1            values
      1            from
      1	          table
      1           select
      2           backup
      2           mysqldump
      3           mail
      3           sendmail
      4           /bin/csh
But I would like it to be : Tip Number Keyword
      1           insert values from table select
      2           backup mysqldump
      3           mail sendmail
      4           /bin/csh
The code is currently : $result = MYSQL_QUERY("SELECT * FROM keyword ORDER BY id"); echo "<center><u><b><br>Keyword Dump</b></u></center>"; echo '<center><table BORDER=0 BGCOLOR="#CCFFFF" ><tr BGCOLOR="#000099"><td BGCOLOR="#000099">'; echo '<center><b><font color="#FFFFFF">Tip Number</font></b></center></td><td>'; echo '<center><b><font color="#FFFFFF">Keyword</font></b></center></td><td>'; echo '<center><b><font color="#FFFFFF">Action</font></b></center></td></tr><tr>"; //get results & output to browser
        	while($row = mysql_fetch_array($result)) {
                	echo "<tr><td ALIGN=\"TOP\"><center>";
           	echo $row["id"];
          	echo "</center></td>";
echo "<td ALIGN=\"TOP\"><center>";
                	echo $row["word"];
                	echo "</center></td>";
$row_number = $row["id"]; echo "<td><center>"; echo '<a href="admin.php3?sql_query=DELETE+FROM+keyword+WHERE+id=',$row_number,'">Delete</a>';
	            echo "</center></td></tr>";
}
        echo "<br></td></tr></table></center>";
        mysql_free_result($result);
How should I do this? Regards Simon Steed

« previous php.general (#590) next »