Re: PHP and MS Access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: pgprSKOKNKQ8N.pgp
Description: PGP signature


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux