Skelethor

This is what I want to do: I have printed out my items of my database in 1 single line. Every row in my database is a new line when it's printed out. Like this: Name, First Name, E-mail, Adres Name2, First Name2, E-mail2, Adres2 ... Now I want to work with the lay-out. Like this: [b]Name First Name E-mail Adres[/b] ------------------------------------------------- Mister X 1@mail Street 1 Mister Y 2@mail Street2 All this in a nice html table with border =1 (all different cells without the line under the headlines) Here's my code: <?php $username="Administrator"; $password="********"; $database="newstravel"; mysql_connect('localhost',$username,$password); mysql_select_db($database); $query = 'INSERT INTO login VALUES("","'.$_POST['txtLoginnaam'].'", "'.$_POST['txtPaswoord'].'", "'.$_POST['txtVoornaam'].'", "'.$_POST['txtNaam'].'", "'.$_POST['txtAdres'].'", "'.$_POST['txtEmail'].'")'; $bInsert = mysql_query($query); if(!$bInsert) { echo 'Fout tijdens invoegen'; } $query="SELECT * FROM login"; $sqlResult=mysql_query($query); while ($aUsers = mysql_fetch_assoc($sqlResult)) { echo ' Loginnaam: '.$aUsers['Loginnaam'].' Paswoord: '.$aUsers['Paswoord'].' Voornaam: '.$aUsers['Voornaam'].' Naam: '.$aUsers['Naam'].' Adres: '.$aUsers['Adres'].' E-mail: '.$aUsers['E-mail']; echo "<br>"; } ?> Thx...

Here is my code: <?php $username="Administrator"; $password="********"; $database="newstravel"; $loginnaam=$_POST['txtLoginnaam']; $lpaswoord=$_POST['txtPaswoord']; $voornaam=$_POST['txtVoornaam']; $naam=$_POST['txtNaam']; $adres=$_POST['txtAdres']; $email=$_POST['txtEmail']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Kan de databank niet selecteren!"); $query = "INSERT INTO login VALUES ('','$loginnaam','$paswoord','$voornaam','$naam',' $adres','$email')"; mysql_query($query); $query="SELECT * FROM login"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<b><center>Overzicht leden</center></b><br><br>"; $i=0; while ($i < $num) { $loginnaam=mysql_result($result,$i,"Loginnaam"); $paswoord=mysql_result($result,$i,"Paswoord"); $voornaam=mysql_result($result,$i,"Voornaam"); $naam=mysql_result($result,$i,"Naam"); $adres=mysql_result($result,$i,"Adres"); $email=mysql_result($result,$i,"E-mail"); echo " Loginnaam: $loginnaam Paswoord: $paswoord Voornaam: $voornaam Naam: $naam Adres: $adres E-mail: $email"; $i++; } ?> And here is the code of my little form: <form method="post" action"insert.php"> <table width="50%" border="0"> <tr> <td>Voornaam:</td> <td><input type="text" name="txtVoornaam"></td> </tr> <tr> <td>Naam:</td> <td><input type="text" name="txtNaam"></td> </tr> <tr> <td>Adres:</td> <td><input type="text" name="txtAdres"></td> </tr> <tr> <td>Loginnaam:</td> <td><input type="text" name="txtLoginnaam"></td> </tr> <tr> <td>Paswoord:</td> <td><input type="text" name="txtPaswoord"></td> </tr> <tr> <td>E-mail:</td> <td><input type="text" name="txtEmail"></td> </tr> </table> <p> <input type=submit name="cmdOpslaan" value="Verzenden"> </p> <p> </form> I don't know what's wrong. But it just don't works... Thx allready...