Hi there! I think it's a pretty easy one, but I'm quite new to PHP... I managed to create a database with a table that I use to store personal data: My address book The fields are name, address, email, and so forth. Now I have a loop in a page that cycle through all my entries and displays them like this (imagine a beautiful HTML formatting to top it!): John Smith Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx ------------- Martin Duval Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx ------------- Alan Smithee Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx ------------- etc. Here is the code I use (I'm french so there are some french comments and caracters) =========================== START (Sample 1) ============================== mysql_connect($host,$user,$password) or die("Impossible de se connecter à la base de données ".$database); $result = mysql_db_query($database,"select * from addressbook"); while ($row = mysql_fetch_object($result)) { if($row->prenom != "") { echo "<span class=\"NomPrenom\">".$row->prenom."</span>"; } if($row->nom != "") { echo "<span class=\"NomPrenom\"> ".$row->nom."</span>"; } if($row->teldomicile != "") { echo "<br>\n"; echo "<img src=\"/interface/icons/domicile_phone.gif\" align=\"absbottom\" alt=\"Téléphone domicile\"> \n"; echo $row->teldomicile; } if($row->telmobile != "") { echo "<br>\n"; echo "<img src=\"/interface/icons/mobile.gif\" align=\"absbottom\" alt=\"Téléphone mobile\"> \n"; echo $row->telmobile; } if($row->telbureau != "") { echo "<br>\n"; echo "<img src=\"/interface/icons/bureau.gif\" align=\"absbottom\" alt=\"Téléphone bureau\"> \n"; echo $row->telbureau; } if($row->email != "") { echo "<br>\n"; echo "<img src=\"/interface/icons/email.gif\" align=\"absbottom\" alt=\"Adresse e-mail\"> \n"; echo "<a href=\"mailto:".$row->email."\">".$row->email."</a>"; } if(($row->rue != "") || ($row->codepostal != "") || ($row->ville != "") || ($row->pays != "")) { echo "<br>\n"; echo "<img src=\"/interface/icons/adresse.gif\" align=\"absbottom\" alt=\"Adresse\"> \n"; } if($row->rue != "") { echo $row->rue; echo " - "; } if($row->codepostal != "") { echo $row->codepostal; echo " "; } if($row->codepostal != "") { echo $row->ville; echo ", \n"; } if($row->pays != "") { echo $row->pays; } echo "<br><br><br><hr><br><br><br>\n"; } mysql_free_result($result); mysql_close(); // FIN Affichage et formatage de la table Address Book ?> ============================ END (Sample 1) =============================== What I want to do is have the options to modify and delete an entry, that would look like this: John Smith Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx >> Modify | Delete ------------- Martin Duval Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx >> Modify | Delete ------------- Alan Smithee Phone (home): xxxxxxx Phone (mobile): xxxxxxx Phone (office): xxxxxxx address: xxxxxxx email: xxxxxxx >> Modify | Delete ------------- I managed to have the option to add a new entry to the list with the follow code triggered via a form: =========================== START (Sample 2) ============================== <? $host = "localhost"; $user = ""; $password = ""; $database = "mabase"; mysql_connect($host,$user,$password); echo $nom."<br>"; echo $prenom."<br>"; echo $teldomicile."<br>"; echo $telmobile."<br>"; echo $telbureau."<br>"; echo $email."<br>"; echo $rue."<br>"; echo $codepostal."<br>"; echo $ville."<br>"; echo $pays."<br>"; //$nom = "Dupont"; //$prenom = "Jean"; $ok = mysql_db_query($database, "insert into addressbook (nom,prenom,teldomicile,telmobile,telbureau,email,rue,codepostal,ville,pays) values ('$nom','$prenom','$teldomicile','$telmobile','$telbureau','$email','$rue',' $codepostal','$ville','$pays')"); ?> ============================ END (Sample 2) =============================== But I would like to be able to have an alphbetical view (A>Z or Z>A) whereas here a new entry is simply appended at the end of the table and displayed in that order... Summary: - How do I add the Modify/Delete buttons for each entry? - How can I display the results in an alphabetical order? If you read to this point, thank you already! any help, resource, tutorial, example is greatly appreciated! Sébastien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]