I am going to suggest you go to www.thickbook.com, look at some examples there about connecting to database. I highly recommend Julie Meloni's book. She has written two-PHP Essentials and PHP Fundamentals. Use the Essentials book. Pick up a copy. She walks you through the basics of databases.
I use access all the time. She likes mysql.
but the ideas about tables and how to connect to databases are good.
--------------------here is some code--------
"<?php
// create connection
$connection = odbc_connect("DataSourceName","username","password")
or die("Couldn't connect to datasource.");
// create SQL statement
$sql = "SELECT COFFEE_NAME, ROAST_TYPE, QUANTITY
FROM COFFEE_INVENTORY
ORDER BY QUANTITY DESC";
// prepare SQL statement
$sql_result = odbc_prepare($connection,$sql)
or die("Couldn't prepare query.");
// execute SQL statement and get results
odbc_execute($sql_result)
or die("Couldn't execute statement.");
// format result in HTML table
odbc_result_all($sql_result,"border=1");
// free resources and close connection
odbc_free_result($sql_result);
odbc_close($connection);
?>
