|
|
Posted by AnrDaemon on 01/29/08 20:53
Greetings, Ivan Marsh.
>>>>I'm trying to adapt a PHP script that was written to use MySQL, so
>>>>that it will work with an MSAccess MDB file.
>>>>
>>>>An important part of the script makes use of the SQL "LIMIT" keyword
>>>>available in MySQL. eg: "SELECT MyField FROM MyTable LIMIT 40,10" to
>>>>select 10 records beginning at the 41st record.
>>>>
>>>>Can anyone tell me how I can achieve this same functionality when
>>>>using ODBC functions to access an MDB file? I think I can set ROWCOUNT
>>>>(or possibly TOP) to retrieve only 10 records but how do I get it to
>>>>start at the 41st record?
>>>
>>> OK - never mind. Thanks anyway.
>>>
>>> I finally figured out the right words to google for and found what I
>>> was looking for.
>> Care to share?
> SELECT [TOP n] fieldlist FROM tablelist;
> Not exact replacement, but still some help...
To add a word in the topic:
Solution (and amount of data returned by such query) is depends on Your needs.
I.e. I have started learning PHP by developing a small news feed based on MS
Access dabase.
And the query
SELECT TOP 10 * FROM [news_headers] ORDER BY [date] DESC;
were EXACTLY fits my needs.
--
Sincerely Yours, AnrDaemon <anrdaemon@freemail.ru>
Navigation:
[Reply to this message]
|