Thank you very much for your help.
If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP.


Ideally, I would use Oracle but it is probably outside of our budget.

- matt



Bastien Koert wrote:

Here is a basic connect script. I would stringly recommend against using access, use mysql instead.

<HTML>
 <HEAD>
 </HEAD>

 <BODY>

   <?php

     // Program to test connecting to a Microsoft Access ODBC Data Source
     $connection = odbc_connect("postcard", "", "");
     print "Connected to datasource<BR><BR>";

     if ($result = odbc_exec($connection, "SELECT * FROM postcard"))
       print "Command executed successfully<BR><BR>";
     else
       print "Error while executing command<BR><BR>";

// Print results
while(odbc_fetch_row($result))
print odbc_result($result, 1) . " " . odbc_result($result, 2) . " " . odbc_result($result, 3) . " " . odbc_result($result, 4) . " " . odbc_result($result, 5) . "<BR>";


     odbc_close($connection);
     print "<BR>Connection closed.";

   ?>

 </BODY>
</HTML>

bastien


From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] microsoft access
Date: Thu, 30 Sep 2004 21:28:48 -0500

Does anyone know of a good online source for using php and microsoft access. I don't want to have to use asp.
Thank you for your time.


Matthew Perry

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


_________________________________________________________________
MSNŽ Calendar keeps you organized and takes the effort out of scheduling get-togethers. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSNŽ Premium right now and get the first two months FREE*.



-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to