How to sort my sql data -

paulbray

<link href="CSS/Level3_2.css" rel="stylesheet" type="text/css" />
<?php 

$dbc = mysql_connect('localhost','root','') or die ("Can't connect to database");
mysql_select_db('consoleentertainmen_518181_db1') or die ("Can't connect to table");

$sort_titles = mysql_query ("SELECT product_MerchantProductID, product_Name,product_Description,product_OnWeb, SKU_Stock, SKU_Price FROM tbl_products INNER JOIN tbl_SKUS ON tbl_products.product_MerchantProductID=tbl_SKUS.SKU_MerchSKUID ORDER BY product_Name ASC");
$games = mysql_query("SELECT product_MerchantProductID, product_Name,product_Description,product_OnWeb, SKU_Stock, SKU_Price FROM tbl_products INNER JOIN tbl_SKUS ON tbl_products.product_MerchantProductID=tbl_SKUS.SKU_MerchSKUID") or die ("Games query is broken");

$numrows = mysql_num_rows($games);

$row = mysql_fetch_assoc($games);

echo '<table align="center" width="80%">

<tr>
<td align="left"><a href=""><b>Edit</b></a></td>
	<td align="left"><a href=""><b>Delete</b></a></td>
	<td align="left"><a href=""><b>SKU</b></td>
	<td align="left"><b><a href="">Title</a></b></td>
	<td align="left"><a href=""><b>Price</a></b></td>
	<td align="left"><a href=""><b>Stock</a></b></td>
</tr>
';

while ($row = mysql_fetch_array($games, MYSQLI_ASSOC))
{
echo '<tr>
<td align="left"><a href="edit_user.php?id=' . $row['Product_ID'] . '">Edit</a></td>
		<td align="left"><a href="delete_user.php?id=' . $row['Product_ID'] . '">Delete</a></td>
<td>' . $row['product_MerchantProductID'] . '</td>
<td>' . $row['product_Name'] . '</td>
<td>&pound;' . $row['SKU_Price'] . '</td>
<td>' . $row['SKU_Stock'] . '</td></tr>';
}

mysql_free_result($games);
?>

I need to sort the list via product_Name, SKU_Price and SKU_Stock, I am trying to learn but struggling on some bits

Weedpacket

You mean [font=monospace]...ORDER BY product_Name, SKU_Price, SKU_Stock[/font] or some permutation thereof doesn't work for you?

paulbray

Weedpacket;10992297 wrote:
You mean [font=monospace]...ORDER BY product_Name, SKU_Price, SKU_Stock[/font] or some permutation thereof doesn't work for you?

I am struggling with how to add them into the script when a user clicks the table header to sort by column selected, I understand setting up queries but linking them into the script is beyond me at present :-p

johanafm

You either have to resort the data using javascript, or have the query executed again using a different order by clause, which can be done either by a new page request or an XMLHttpRequest.

PutsDrusa

VigRX Gain 5 Month Purveying Virile Enhancemnt Penis Enlargement Pills Jumbo Providence, Order Nowadays! It is in truth an fabulous In stock VigRX Added 5 Month Supply Masculine Enhancemnt Penis Enlargement Pills.I highly recommend Rummage sale VigRX Extra 5 Month Afford Manful Enhancemnt Penis Enlargement Pills payment anyone.I absolutly be wild about it!

We Look like and Determine Scanty Prices to offer You Here! Worst Offers Today!

For men who fancy bigger, harder, longer-lasting erections, there's from time to time VigRX Plus. VigRX Bonus is the penis enhancement offshoot that delivers the most results in the shortest time. You'll bear a larger penis when you're aroused, with greater erection volume and longer-lasting procreative performance.

Month #1: The first alteration that you can count on to take to is longer lasting erections. TVigRX Increased by 5 Month Provisioning Manful Enhancemnt Penis Enlargement Pills Do not Miss!! After men who in need of bigger, harder, longer-lasting erections, there's stylish VigRX Plus. VigRX Plus is the penis enhancement by-product that delivers the most results in the shortest time. You'll have a larger penis when you're aroused, with greater erection right stuff and longer-lasting earthy performance.

Month #1: The earliest substitution that you can expect to take is longer lasting erections. T... VigRX Added 5 Month Give Manful Enhancemnt Penis Enlargement Pills Read More

Drive Less And Prevent More,Do not Want Our Foremost Act on

More Details & Swallow Instant!

Cheapest Price VigRX Increased by 5 Month Stocking Virile Enhancemnt Penis Enlargement Pills

Kindest Buy off VigRX Addition 5 Month Supply Male Enhancemnt Penis Enlargement Pills

On Sale VigRX Together with 5 Month Gear up Manful Enhancemnt Penis Enlargement Pills

Detract from VigRX Plus 5 Month Come up with Manly Enhancemnt Penis Enlargement Pills