tables

[Anon]

I put this subject as tables as I would like to know how to create table rows from a sql querry against a databse. ie

If I had a database with peoples names in I would like to put them into a table but not in one line but in a couple or table rows
ie
<tr><td>$a_row[name]&nbsp;</td><td>$a_row[name]&nbsp;</td>,<tr>

so I would need to do a count first on the data before it would know how many rows to create.

I am lost on how to do this could someone explain please

Lee

[Anon]

You could just loop through the result set create rows with each loop:

<table cols=\\\\"1\\\\">

do {
print \\\\"<tr><td>\\\\".$a_row[\\\\"name\\\\"].\\\\"</td></tr>\\\\";
} while($result = mysql_fetch_array($query));

</table>

No need to count items in the array, it will keep making rows as long as there are items in the array.

I hope this is what you were looking for.

-Jamison

[Anon]

Take out all of those backslashes..I don't know how those got in there. I don't post on here often.

[Anon]

Thank J

Lee