[RESOLVED] Displaying MySql data in an html table

IceRegent

I dont know if this has been addressed before, but I am trying to display my MySql data in a table format. I can get the data out from a query just fine, but I need to know a way to neatly arrange the displayed data in nice columns under header titles for each data field. i have an html table with the headers in it, and would like to stack up the subsequent query's in line under the headers. How is this done? I am getting frustrated.

Thanks in advance for the help.

Ice

Roger_Ramjet


$sql = "SELECT name, address, phone FROM table";
$result = mysql_query($sql) or die ($sql . '<br />' . mysql_error());
if ($result && mysql_num_rows($result)>0) {

 echo '<table><tr><th>Name</th><th>Address</th><th>Phone</th></tr>';

 while ($row=mysql_fetch_array($result)) {
   echo '<tr><td>' . $row['name'] . '</td>';
   echo '<td>' . $row['address'] . '</td>';
   echo '<td>' . $row['phone'] . '</td></tr>';
 }

 echo '</table>';

}

babil

You coulduse something like this

  function load_table()   

{     

       include('inc/database.inc.php');      //your database login                                 

       $connection = mysql_connect($db['host'],$db['uid'],$db['pwd']);  

   if($connection)   
          {       
            mysql_select_db($db['db']);       
            $sql = 'SELECT  cell1, cell2  FROM mytable ';     
            $result = mysql_query($sql);       
           if($result)     
             {   
               echo "<table>";  //output html table
               while($table = mysql_fetch_object($result))    // for every row      
                  { 
                   echo " <tr>";        //open html tr
                   echo"<td>$table->cell1</td>";   //open html td, content of cell1 close td       
                   echo"<td>$table->cell2</td></tr>";  //dito      
                   }
               echo "</table>";  //when all the rows read, close the table
            }

         mysql_close();     //close sql connection
 } 
}

ofcourse this is a very generic approach, there are many ways to do it. Take this as a starting point. With time you'll be able to write scripts that really suit your needs.

cheers
vassilis

IceRegent

Thank you for the response Roger Ramjet; The method you posted to me works absolutely wonderful. I appreciate the help!
🙂 🙂