Split Data

[talkster5]

Hi there,

I was basically wondering how i would go abouts splitting up my query to the database and entering each row into a seperate row on my html table.

So basically if i have in the database:

Bob Dread 26/07/34
Harry Fred 24/11/56

In the html table it would show the same but i dont want to have to add a new row into the html table manually everytime i add a new record to the database so could i make it add a new row automatically?

[lazzerous]

I think i know what you're trying to convey..

let's say your query to the database (I'll assume MySQL) is this:

$get_entries = mysql_query("select full_name, dob from people");

Now we want to loop through weach entry, and put each set of results in a different <tr> statement within an HTML table:

<?
echo "<table>\n";

while ($row=mysql_fetch_array($get_entries))
    {
    echo "  <tr>\n";
    echo "    <td>$row[full_name]</td>\n";
    echo "    <td>$row[dob]</td>\n";
    echo "  </tr>\n";
    }

echo "</table>\n";

is that what you were looking for?

[talkster5]

I think thats the kind of script i wanted. Thanks ill try it when i get home later.

[talkster5]

works great, thanks.