Re: PHP and MS Access
| From: | list at elliott dot uk dot com | Date: | Sat, 08 Jan 2005 15:39:12 +0000 |
| Subject: | Re: PHP and MS Access | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-25275@lists.php.net to get a copy of this message | ||
Hi php-windows,
Historians believe that on 08 January 2005, at 14:31:00 +0200 (which was
12:31 where I live) PHP Windows Mailing List wrote and made these points
> I'm having to port a MySQL system to MS Access, but some of the SQL is not
> working on MS Access.
> MySQL statement : select * from po limit 0,20
> When I execute that sql statement using odbc_exec, it says there is a synta
> error in the "FROM" clause.
Try
Select top 20 * from po
I believe that limit is MySQL specific.
--
David
Attachment: [application/pgp-signature]
Attachment: [application/pgp-signature]