[SOLVED] help with sorting records

[DrTrans]

I need some help with figuring out sorting

 

$connect = ('localhost','root','');
mysql_select_db("tester");
$query = "SELECT * FROM tester";
$result = mysql_connect($query);
while($row=mysql_fetch_array($result)) {
$id    = $row['id'];
$prop = $row['propertyname'];

echo "$prop -- $id ";
}

 

Now i want it to sort it A to Z by first letter of $prop.

 

Thanks

 

 

DrTrans

[bubbasheeko]

Hi DrTrans,

 

Change your query to this:

 

$query = "SELECT * FROM tester SORT BY tester DESC"; 

 

or it is ASC rather than DESC...kinda tired to think lol

[DrTrans]

I goofed myself

 

Would this be sufficent:

 $query = "SELECT * FROM tester where Active = '$active ' SORT BY tester ASC";

[DrTrans]

Just in case others are wondering i fixed this problem by doing this

 

 $query = "SELECT * FROM tester WHERE active = "$active" ORDER BY tester ASC";

 

Thanks

Dr Trans