[Resolved] Showing entire MySQL Table as HTML

kiwibrit

I am brand new to php - and to MySQL.
I have loaded a test table into the data base - and need to reproduce it into an HTML table. The problem is representative of a series of tables which will have varying numbers of rows and columns. I am trying to create a standard php script to handle that.

For the test table, I have found that the following code gives me a display that shows the bones of what I want - but not with the results in an HTML table

<?php
$username = "#$!#$!#*$!";
$password = "yyyyyyyyy";
$hostname = "zzzzzzzzz";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
mysql_select_db("aaaaaaa") or die ("Unable to select database!");

$query = "SELECT * FROM tablename";

$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());

while ($row = mysql_fetch_row($result))

{
echo "$row[0]",":";
echo "$row[1]",":";
echo "$row[3]" ,":";
echo "$row[4]" ,":";
echo "$row[5]" ,":";
echo "$row[6]" ,":";
echo "$row[7]",":";
echo "$row[8]",":";
echo "$row[9]" ,":";
echo "$row[10]",":";
echo "$row[11]" ,":";
echo "$row[12]";
echo "<br>";
}

mysql_close($dbh);

Of course, "." appeared in echo so that I could see what was going on.
I cannot figure how to get the data from each field of each row into an HTML table handling each column and row. I'd be grateful if someone could point me at a suitable link, or give me a quick steer, to do that.

Installer

echo '<table>';
while ($row = mysql_fetch_row($result)) { 
    echo '<tr>';
    foreach ($row as $item) {
        echo '<td>' . $item . ':</td>';
    }
    echo '</tr>';
}
echo '</table>';

thorpe

echo '<table>';
while ($row = mysql_fetch_row($result))
{
  echo '<tr>';
  echo '  <td>'.$row[0].'</td>';
  echo '  <td>'.$row[1].'</td>';
  echo '  <td>'.$row[3].'</td>';
  echo '  <td>'.$row[4].'</td>';
  echo '  <td>'.$row[5].'</td>';
  echo '  <td>'.$row[6].'</td>';
  echo '  <td>'.$row[7].'</td>';
  echo '  <td>'.$row[8].'</td>';
  echo '  <td>'.$row[9].'</td>';
  echo '  <td>'.$row[10].'</td>';
  echo '  <td>'.$row[11].'</td>';
  echo '  <td>'.$row[12].'</td>';
  echo '</tr>'; 
}
echo '</table>';

ps: or you could do it as above ^ hehe

kiwibrit

Thanks, Installer. Really quick answer. Really good.

Jack_McSlay

adding further suggestions, you could also look at mysql_fetch_assoc(), with it you can also point out the key name of the value, like (modifying installer's code):

echo '<table>';
while ($row = mysql_fetch_assoc($result)) { 
    echo '<tr>';
    foreach ($row as $key =>$item) {
        echo '<td width="150">' . $key .'<td>';
        echo '<td>' . $item . ':</td>';
    }
    echo '</tr>';
}
echo '</table>';

this will also point also what are the output values like
name - hero
age - 24'

kiwibrit

Thanks, Jack. I'd already started to think beyond the brief my boss gave me (it's a company web page). Once the first stage of the project is complete, I'll be looking at that idea again.

And I wish I was still 24!!