I'm quite a newbie ot php/mysql, so my question might be oversimple (though i tried for hours to understand..)
I'm making an addressbook, as a try out, to see how it al works. All is great actually, but only the sorting of the addresses seems complicated for me..
I have a databse called 'addressen', and four fields of this db are called 'id', 'name', 'surname' and 'address'
To display the content i use this:
<?
include( "file_that_connects_with_my_database.php");
$result = mysql_query(
"SELECT id, name, surname, address FROM addresses");
if (!$result) {
echo( "<p>Error performing query: " .
mysql_error() . "</p>");
exit();
}
while ( $row = mysql_fetch_array($result) ) {
$addressid = $row["id"];
$nametext = $row["name"];
$surnametext = $row["surname"];
$addresstext = $row["address"];
//the table
echo( "<table width='100%' border='0' cellspacing='0' cellpadding='0'><tr><td>");
echo( $addressid. "</td><td>");
echo( $nametext. "</td><td>");
echo( $surnametext. "</td><td>");
echo( $addresstext "</td><td>");
echo( "</tr></table>");
}
?>
This scripts works, but.. my desire is now to be able to sort the output, wich is generated by the 'while' loop, for instance on 'name', or on 'surname' . sort(), ksort()? I couldn't understand the explanations i found (and so declared myself as newbie :)
Can anybody help me with this? I would be delighted...
Thanks in advange!
Bart Koppe
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
