php connect to msaccess2000?

Can PHP connect to msaccess 2000 or do I need to download mysql?

Does Apache server have mysql ( because I have that on my pc ) and how do I transfer msaccess to mysql?

 

Yes,
You can connect PHP with MS-Access & you no need to download mysql for this. Apache Server does not have mysql, If you need you can use WAMP server, this have PHP, MySQL & Apache.

 

ok so the next question is how do I connect? I know ASP and if I leave the database in the root folder as long as I write the right pathname it'll detect it.

Is it the same with PHP? Do I need to go through ODBC from the settings of my computer to make it functional?

I was tutoring myself with http://www.w3schools.com/php/php_mysql_intro.asp
If I'm going to use MSAccess ( which I prefer ) then how different is it from the tutoring link above?

 

For that you can connect using ODBC, here is a PHP & MS Access Tutorial:

phpfreaks.com/tutorials/61/0.php

 

ok let's say I want to retrieve the first 22 records...how does that work?

				
$query = odbc_exec($odbc, "
[B]Select DISTINCT(recordType), Book_Title, Book FROM Bible ORDER BY Book ASC[/B]
") or die (odbc_errormsg());

Code (markup):

 

Ok I think I need to further explain. My intention is to make 3 columns of a table where each column has 22 books listed. How do I do that?

Or is there a way of breaking 22 and inserting <tr><td></td></tr> and then continuing?