Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
Hans Lellelid wrote: You definitely should do your own benchmarks. Bear in mind that the ADOdb benchmarks test a certain type of behavior -- namely repeated select statements. Also bear in mind that the speeds of the different layers are going to be inversely proportional to how well they

Re: [PHP-DB] Re: Newbie Questions

2004-09-03 Thread Pete Holsberg
On Thu, 2 Sep 2004, Torsten Roehr wrote: I think I need just a little push in the right direction. After I send the above SELECT command, how do I get the result to appear on a web page? mysql_query() will return a result set. There are different functions to extract the rows from it. I

RE: [PHP-DB] Re: Newbie Questions

2004-09-03 Thread Hutchins, Richard
Coming in late on this topic, but... Database. SELECT firstname, lastname, address FROM TABLENAME ORDER BY lastname ASC; Use ASC or DESC to order your query results. When you iterate over the result as Torsten indicated, everything will be in the order you specify. Check out the MySQL docs for

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Lester Caine
Jeffrey Moss wrote: Doesn't do Firebird yet ;) - but it looks interesting. As long as it has not made the mistake of using MySQL as the SQL standard. Many other packages are simply MySQL wrappers with cobbled support for a couple of other engines. I was curious about Firebird as I've heard it

[PHP-DB] An old question...

2004-09-03 Thread Lic. Daniel Alfredo Betancourt Reboso
Hi everyone!! Certainly it is an old question. How can I start learning PHP?. I need to use it with MySQL. Any suggestions? I´m a none English speaker. Thank´s Daniel.. INFOSOL Webmail http://webmail.gtm.sld.cu/imp/ -- PHP

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Hans Lellelid
Lester Caine wrote: snip So you start with ADOdb datadict and build the database from that - works well when adding any supported engine. Reserved words which differ between engines are another problem area though. Yeah, but not just reserved words -- but even what is allowable in a query.