RE: [phplib] Cross DB SQL From: Chris Johnson (chris <email protected>)
Date: 03/07/01

Most databases implement to the 1992(?) SQL standard, and then add
extensions from there. The "LIMIT" clause is a MySQL extension, so will
not work with most other databases. The rest of your statement appears
to be standard SQL and should work on just about every database.

-----Original Message-----
From: Peter Bowyer [mailto:reywob <email protected>]

Is there a chart anywhere which shows what SQL will work with all
databases? For instance will the following work with databases other
than
MySQL:

SELECT count(*) AS count,PostImage FROM $PostStatsTable GROUP BY
PostImage
ORDER BY count DESC LIMIT $ListTop

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>