Displaying MySQL queries with PHP

Anon

Can anyone please point me in the right direction to display MySQL query results in tables and cells.

I'm recently self-taught on PHP and gained enough knowledge to query my MySQL database and display results in a simple format. I am using PHP in conjunction with HTML. Thanks so much in advance.

Anon

Here is an ASP multiplication table. It displays 10 rows of 10 columb You loop <tr>'s and <td>'s to be displayed in html by the server. Hope this helps, I don't know php, but it should be similar. I'm starting to try and learn php also.

<h1>Times table</h1>

<table border=1>
<%
for row = 1 to 10
Response.Write "<tr>"

            for col = 1 to 10
	Response.Write "<td>"
	Response.Write row * col
	Response.Write "</td>"
	next

	Response.Write "<tr>"
	next
%>

</table>

</body>

Anon

If you have mastered querying and output, you're pretty much there.

echo "<table>";

echo "<tr><td>Heading1</td><td>heading2</td>";

while ($bar = mysql_fetch_row($foo){
echo "<tr>";
echo "<td>$bar[0]</td><td>$bar[1]</td>" ;
echo "</tr>";
}

echo "</table>"

et cetera.

Or substitute mysql_fetch_array, mysql_fetch_object, et cetera.

Anon

I went to Code Gallery, HTML, Tables on this site and found a few example scripts to try. After a few changes to the script I was able to display my queries in a table with alternating row colors (on one I had to change gray to blue for a better appearance). Thanks to those who replied. I welcome further comments.