[SOLVED] Displaying SQL Database On PHP Page?

[snuggles79]

This is probably really simple to achieve but I've been going round and round in circles and now it's doing my head in  ???

 

How do I display everything that's in an SQL database on a PHP webpage as a table?

 

Thanks in advance!

[ted_chou12]

http://us.php.net/manual/en/function.mysql-fetch-array.php

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
    die("Could not connect: " . mysql_error());// connect to db
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable"); //ur query here

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    printf("ID: %s  Name: %s", $row["id"], $row["name"]);//echo out here
}

mysql_free_result($result);
?>

Ted

[snuggles79]

Thanks for that Ted but I think I must be in dumb mode tonight.

 

I get the first bit because that just connects to the database.

 

But what does id, name mean? And what should I be putting as my id, name if I want it to display all columns of all records?

[ted_chou12]

id and name refers to the column, for each table u would have columns and rows, rows are just ur entries, and columns r different variables u can store for each entry:

idname

ted_chou12Ted

snuggles79snuggles

Ted

[snuggles79]

All done now Ted thank you