Re: access database on linux

I think that the only way to access Access from PHP you have to use ODBC. The loop is easy select * from the_table; after than $num_rows=mysql_num_rows($result); $showed = 0; for ($counter=0;$counter<=$num_rows;$counter++){ $ar=mysql_fetch_assoc($result); foreach ($ar as $key=>$value){ echo $value; } } -- Andrey Hristov Web Developer IcyGEN Corporation BALANCED SOLUTIONS http://www.icygen.com On Tuesday 09 October 2001 16:49, you wrote: > Hi > > I have a few msaccess dbs (.mdb files) that I need to open, extract and > join data then update a MySQL database. I want to open MsAccess files > (.mdb) using PHP, loop through results and create a .csv filethe just lod > content into a MySQL table. > > Say my file is called first.mdb > I am running RH6.2 and PHP4 > > How do I open a .mdb file? Do I need to use ODBC? > Any tutorials or example scripts. > > Regards > > Ajdin