Table sorting with PHP/MySQL
| From: | Simon Steed | 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