which DB to use?

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 <mwperry@mail.uh.edu> To: php-db@lists.php.net 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*.