Display results from a - z

[webandwe]

Hi,

How do I display the row results from a-z?

Example:

Select a category - a b c d e f g .... And if the user click b, then all the products starting with be is displayed?

Thanks


[PHP]
<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("gamehunt_co_za_store", $con);

$result = mysql_query("SELECT * FROM products_description ORDER BY products_name");

while($row = mysql_fetch_array($result))
{
echo "<a href=\"$row[products_url]\">$row[products_name]</a>";
echo "<br />";
}mysql_close($con);
?>
[/PHP]

[samatair]

I think you kept the categories in a separate table and product descriptions in a separate table. if that is the case you could use a join query to select the records and filtering out the category which you selected by using the
category like "$category_letter%".

[Markus]

use WHERE
So, if you have your data stored in the table and also a column name which has the catagory theyre in (a, b, c, d...)
[php]
$_c = $_GET['letter']; // remember to sanatise this.
SELECT * FROM `table_name` WHERE `catagory` = '{$_c}'";
[/php]
Hope this helps!