Re: access database on linux

Is the answer to this iodbc? Does it mean that I have to recompile php and apache? Ajdin On Tue, 9 Oct 2001, Andrey Hristov wrote: > 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 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >