Select * and display it on a page

[JoeVB]

I am looking for a simple page that, when called, will just do a select * from a table and display the results in a readable form on the page. I am thinking it will involve a table of some sort.

Does anyone have anything like this all setup so I don't have to make it? I can try to make it, I am new to PHP but not new to programming so it might take a bit to learn.

Thanks.

Joe.

[cheese]

Hi JoeVB,

Have a look at SELECT in the PHP Manual

This is a bit of code I use from time to time. Bit untidy, but it should be a starting point.

//Make statements and connect to server
define (NL,"\n");  // makes the page think that .NL is /n for a new line
$sql_server = "localhost";
$sql_username = "username"; // put your username here
$sql_password = "password";  // put your password here
$sql_database = "databasename"; // put your database name here
global $sql_server;
global $sql_username;
global $sql_password;
global $sql_database;
$link = mysql_connect($sql_server, $sql_username, $sql_password)
        or die("Could not connect : " . mysql_error());
    mysql_select_db($sql_database) or die("Could not select database");

$query = mysql_query("SELECT * FROM atable");

print "<table>".NL; // start the table

//Display the rows of data in a table

while ($row = mysql_fetch_array($query, MYSQL_NUM))
{
//this loops for as many records as the query finds
print "<tr>".NL;
print "<td>" . $row[0] . "</h1></td>"; // 1st colum from db
print "<td>" . $row[1] . "</h1></td>"; // 2nd colum from db
print "<td>" . $row[2] . "</h1></td>"; // 3rd colum from db
print "<td>" . $row[3] . "</h1></td>"; // 4th colum from db
print "</tr>".NL;
?>
print "</table>".NL; // Finish table. 

Hope this helps,

Neil.

[JoeVB]

Thanks, looks like what I was after...I will pick it apart and make sure I learn it.

Thanks again.

JoeVB

[cheese]

and spot the mistake.......

I put the ?> in the wrong place !!

Cheers,

Neil.