Here is modified code for your needs. Try copy and pasting it where you need it.
<?php
$username = "Your Username";
$password = "Your Password";
$db = "Your Database Name";
$host = "mysql02.powweb.com";
$link = mysql_connect($host,$username,$password);
if (!$link)
die("Could not connect to database");
mysql_select_db($db,$link)
or die("Database couldn't get selected");
echo "<table>";
$result = mysql_query("SELECT * FROM tablename") or die( 'Invalid SQL '.mysql_error() );
if( mysql_num_rows($result) == 0 ) {
echo 'No results';
die; // Kills script
}
echo "<tr><td><b>Month</b></td><td><b>Birthdays</b></td></tr>";
while ( $a_row = mysql_fetch_assoc($result) ) {
echo "<tr><td>";
echo $a_row['Month'];
echo "</td><td>";
echo "$a_row['Birthdays'];
echo "</td></tr>";
}
echo "</table>";
?>
Let's say you want to generate a table that has the month then the number of birthdays next to it. HTML would be:
<table>
<tr>
<td><b>Month</b></td>
<td><b>Birthdays</b></td>
</tr>
<tr>
<td>December</td>
<td>15</td>
</tr>
etc...
See how the first row is just static information? This is found in the PHP code here:
$result = mysql_query("SELECT * FROM tablename");
echo "<tr><td><b>Month</b></td><td><b>Birthdays</b></td></tr>";
That sets up the basis. Then it loops through your data and puts it underneath those entries.
You can modify this for your needs just by that basic understanding.
(btw, this part is the looping)
while ( $a_row = mysql_fetch_assoc($result) ) {
echo "<tr><td>";
echo $a_row['Month'];
echo "</td><td>";
echo "$a_row['Birthdays'];
echo "</td></tr>";
}