I had someone write a PHP routine for me that reads a database and displays the information via a PHP/HTML application. Here is the first part of the code:
<?php
include('connect/connect.php');
mysql_select_db($database) or die ("Unable to Connect to the database");
$woods = array();
$selectWood = "SELECT * FROM `wood`";
$queryWood = mysql_query($selectWood) or die(mysql_error());
while($item = mysql_fetch_array($queryWood))
{
$woods[$item['index']] = array($item['name'], $item['photo']);
}
How do I get into this database to view, add or delete records. If I may use this example, I know MS Access. With Access I start the Access 2003 , attach the mdb file, open the database and then I have access to all the columns and rows of data in the table. Is there a routine similar to MS Access that allows me to gain access to all the rows and columns the table in the code?
Sam