[RESOLVED] table view

[CybJunior]

Good evening,
I want to ask how can i view full table (like in phpMyAdmin) from my database on my php page?
Lets imagine i have a table called models and it has columns called model_id, model_name. What script should i use to print all table on the page?

Thanks a lot.

[CybJunior]

its realy urgent... its 3 am now and im still trying to do that thing because i need to show it tomorrow morning to one of my teachers. Please help me!

[rincewind456]

<?php

//connect to server and choose database
$conn=mysql_connect("localhost", "user", "password");
$db=mysql_select_db("db_name", $conn);

//run query and hold result identifier in variable $result
$result=mysql_query("SELECT * FROM table_name");

//the first time through I want to print the column names
//in the table header. This variable will be changed to
//FALSE once the table header is laid out
$layout_header=TRUE;

echo "<table border=1>\n";

//This while... loop will grab all results from the query.
//Using MYSQL_ASSOC, the column names are stored as array
//associative indexes.
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
    if($layout_header){
        $layout_header=FALSE;
        echo "<tr>\n";

    //print out each column name as the value of a row in the
    //table header
    while(list($col_name, $col_value)=each($row)){
        echo "<th>$col_name</th>\n";
    }
    //rewind the array pointer so that the values of this
    //row can be displayed in the table body.
    reset($row);
    echo "<tr>\n";
}
//now that the table header is in place, print
//all the values for each row.
echo "<tr>\n";
while(list($col_name, $col_value)=each($row)){
    echo "<td>$col_value</td>\n";
}
echo "<tr>\n";
}
echo "</table>";
?>