PHP SQL - Access query question

Author

Access query question

V23

2004-04-11, 6:31 pm

I'm putting together a website that queries a microsoft access
database through odbc.

For simple queries its similar enough to MySQL that i can manage. But
for the life of me I can't find any online documentation for
forming queries to access.

Specifically: how would one limit the number of results to be returned
by a select statement in access? For MySQL you'd put "limit
20" or whatever at the end of the query, but that doesn't
work for access.

Any help would be greatly appriciated.

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

jvrothjr

2004-04-12, 9:33 am

create the query in access then look at the sql code for that query
and see how it is done.

If you understand everything you know nothing!

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

Sponsored Links