MS Access databases Vs Php??

discussion14php

Hi All,

I'm unable to use all of the SQL with Access databases.
How to solution like this?

SELECT * from tblSection ORDER BY SectionID ASC LIMIT 0,20

Cheers,
discussion14php

AIS4U

discussion14php:

Your query looks OK for a MYSQL database, but I am not sure about Access.

What happens when you run your query?

Are you getting some kind of error message?

The first thing I would do is to check and make sure I have a good connection to the database. If so, then try limiting your query to "SELECT * from tblSection ORDER BY SectionID" and see if that works.

I am sure that much of your query should work with Access.

If that works then try adding the "ASC" and see if that works. Then finally add the "LIMIT 0, 20" and see what happens.

Although I have worked with Access quite a bit, I have never used the "ASC" or "LIMIT" and therefore, I am not sure if they work with Access.

Good Luck

thorpe

There is no LIMIT clause available in access.

discussion14php

Hi,

I have found error like this:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause., SQL state 37000 in SQLExecDirect in C:\Program Files\xampp\htdocs\MS\View.php on line 120

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\Program Files\xampp\htdocs\MS\View.php on line 123

this is code error of my php code :

$result1 = odbc_exec($connID, "SELECT * from tblSection ORDER BY SectionID ASC LIMIT $offset,$count"); on line 120 //(This code I wish to commutation of page on my php code)

while($r = odbc_fetch_array($result1)) on line 123 //( this looping on my pdp code)

I ever done to using code above in the Mysql database. I did't have wrong about that. How to solution about that?

Thanks in advance
discussion14php

dalecosp

thorpe wrote:
There is no LIMIT clause available in access.

Did you read this?

discussion14php

Yeah, I have read about that. I wish to ask how to overcoming to it?, what there is a way for using in Access database.

Thanks in advance
discussion14php

thorpe

What part dont you understand? There is no LIMIT clause in access.

The LIMIT clause is not part of the sql language and unfortunately is not supported by most databases.

What are you relying on the LIMIT clause to do?

If it is for some sort of record paging, you should do a google for 'record paging using asp'. The reason I say this is that access is probably most widely used with asp, and there should be plenty of examples around for paging through records with it.