HomePHP Page 3 - Ordering Columns in DDBB Search Results
The Basic Code - PHP
This article will show you the fastest way to order your database results, via JavaScript (with some work in PHP). It adds some more work to your script, but once you see the results you won't use the approach of adding the ORDER By clause anymore.
Let's write the basic code: it will retrieve the products from the database and display them in a table.
<?
//Connect to the database $conn=mysql_connect('localhost','root','') or die ('Sorry, no connection to database available :-(');
//Perform our query $query='SELECT * FROM test.products';
if (!$res=mysql_query($query, $conn)) { die ('Sorry, query error'); }
//We populate the $output variable with the HTML code //to generate the results table $output='<table><tr style="font- weight:bold"><td>ID</td><td>NAME</td><td>PRICE</td><td>
CODE</td> <td>WEIGHT</td></tr>';
while ($a=mysql_fetch_row($res)) { //Append the table row to our $output variable $output.="<tr id='line$a[0]'><td>$a[0]</td><td>$a[1] </td><td>$a[2]</td><td>$a[3]</td><td>$a[4]</td></tr>"; }
$output.='</table>';
?>
<html> <head> </head>
<body>
<div id='content'>
<?=$output?>
</div>
</body> </html>
Okay, this piece of code should produce this output, a table with all the products on it:
Make sure you check the while loop. We assign each TR element an id, being this id the ID number of the product (the ID number of each product is unique, so we are sure there won't be two TR with the same ID):
PHP 
