Ok with mysql I would have no problem since I got the code for this but using access I have some probs.
Basically I need to get all the data from a table and display it on a webpage using php and tables. very easy. except there is no function which does this easily in ODBC.
$cur = odbc_exec($DB, "SELECT Provider, Account_No, Invoice_Date, Invoice_Total, Outgoing, Incoming, Start_Date, End_Date
then
echo "<table border=1><tr><th>Account_No</th><th>Invoice Date</th><th>Invoice Total</th><th>Outgoing</th><th>Incoming</th><th>Start Date</th><th>End Date</th></tr>\n";
and then while ?? not empty table extract each data field and put it in the corresponding field in the table. I know this is quiete easy but i am new to php and ODBC.
please I ones had the code for this and I lost IT!!!!
