Dear friends,
In this query what precisely needs to be added at alphabetical_field
following ORDER BY
SELECT * FROM mytable ORDER BY alphabetical_field
so that I get output in alphabetical order.
guidance, please.
--------------------------------------------------------------------------
My Php script
-------------------------------------------------------------------------
<?php
include 'menufile.php';
?><center>
<?php
// open the connection
$conn = mysql_connect("localhost", "", "");
// pick the database to use
mysql_select_db("b",$conn);
// create the SQL statement
$sql = "SELECT * FROM euemails ORDER BY alphabetical_field ";
// execute the SQL statement
$result = mysql_query($sql, $conn) or die(mysql_error());
//go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$id = $newArray['id'];
$email = $newArray['email'];
//echo the results onscreen between ""can also //type$id is and &email is
echo " $email <br>";
}
?></center>
