[warrerj]

Sorry if this seems really simple to you but I'm very new to php.

I've got a html table with table headers (5) set up on a page. I want to show the results of a database search on the from, creating a new row for each record returned.

I'm ok with the simple html syntax and have got the php to print the results row by row with a horizontal line between them but can't seem to get the results in a table. I the code I tried was :

...
db connection and query etc.

echo(" <tr> ");
echo(" <td width="20%"> ");
echo($row["customerID"]);
echo(" </td> ");
echo(" <td width="20%"> ");
echo($row["surname"]);
echo(" </td> ");
echo(" <td width="20%"> ");
echo($row["forenames"]);
echo(" </td> ");
echo(" <td width="20%"> ");
echo($row["street"]);
echo(" </td> ");
echo(" <td width="20%"> ");
echo($row["post_code"]);
echo(" </td> ");
echo(" </tr> ");
...
</table>

Can anyone please help ?

Thanks

[NeverMind]

did you have the table's tag started?
I mean did you print any <table border="0" width=" ... > before you start the tables <tr>s and <td>s ?
because in your code you don't seem to have it !

also you don't need all this echos !! just one is enough !
PHP will ignore any spaces or newlines in your code ..

PHP Code:

//we start the table here

echo'<table border="0" width="100%">';



//then we loop through results

while ($row = mysql_fetch_assoc($fetch)) {

echo'

  <tr>

    <td width="20%">'.$row["customerID"].'</td>

    <td width="20%">'.$row["surname"].'</td>

    <td width="20%">'.$row["forenames"].'</td>

    <td width="20%">'.$row["street"].'</td>

    <td width="20%">'.$row["post_code"].'</td>

  </tr>';

}



//close table here..

echo'</table>'; 

now, doesn't this look cleaner !!