On Fri, 15 Nov 2002, William wrote: > I code with PHP and use it to communicate with MySQL, if I started using > PostgreSQL would I have to change my coding to communicate with the > database? Probably, but only slightly. I changed my DB from MySQL to PostgreSQL and had to change each SQL call slightly. It seems to me the difference was PostgreSQL needs to know the number of rows gotten and then loop through them with a for loop, with MySQL I was able to use a while loop without checking the number of rows first. It could have been my inexperience that caused me to miss the obvious, though. In perl there is the DBI module and php has DBX. With it you use a common calling cenvention across a bunch of Databases (FrontBase, Microsoft SQL Server, MySQL, ODBC, PostgreSQL, Sybase-CT, Oracle)
