PHP Sorting MySQL

[tacanty2100]

Ok, So I have a table with customers... But after you add one. The <select> that shows up is unorganized...

 

				$con = mysql_connect("localhost","techportal","tech2196");
				if (!$con)
				  {
				  die('Could not connect: ' . mysql_error());
				  }
				mysql_select_db("innerlink_customers", $con);
				$result = mysql_query("SELECT cust_id, customer FROM customerinfo");
				while($row = mysql_fetch_assoc($result)){
					echo "<option value='" . $row['cust_id'] ."'>" . $row['customer'] . "</option>";
				}

[wildteen88]

What do want to the results to be ordered by? The cust_id field in numerical order

SELECT cust_id, customer FROM customerinfo ORDER BY cust_id ASC

or the customers field in alphabetical order?

SELECT cust_id, customer FROM customerinfo ORDER BY customer ASC

 

if you don't specify an order it will just return the results in the order they where added into the database.

[tacanty2100]

Haha. Well Thank you wildteen88 for that... Been working on this constantly and brain is fried.