BeWebmaster

PHP Function to Generate HTML Table Using MySQL Database Data

Ad

Organize your MySQL database data in HTML tables created on the fly using this PHP function snippet.

Function maketable uses MySQL query and an array of  columns you want to display as attributes. 

function maketable($query, $fieldarray){
//count number of columns
 $columns = count($fieldarray);
//run the query
 $result = mysql_query($query) or die(mysql_error()) ;
 $itemnum = mysql_num_rows($query);
 if($itemnum > 0){ 
  do{   
   echo "<tr>" ;
   for($x = 0; $x < $columns; $x++){
    echo "<td>" .$items[$fieldarray[$x]]. "</td>" ;
   }
   echo "</tr>" ;
  }while($items = mysql_fetch_assoc($result));
 }
}

/* USAGE
echo "<table>";
$fieldarray = array("id","title","description");
maketable("SELECT * FROM bw_news", $fieldarray);
echo "</table>";
*/