ODBC and LIMIT in PHP

Zajil

Hi,

Is it possible to use LIMIT keyword with ODBC? if yes how?

This is my select statement , what is wrong ?

SELECT * FROM REQUEST ORDER BY Req_time DESC  LIMIT 0,10

Lars_Berg

Whether limit is supported or not has nothing to do with ODBC. It depends entirely on which DBMS you are using.

What's your actual problem?

Zajil

Thanks for replay, my problem is that:

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'LIMIT'., SQL state 37000 in SQLExecDirect in c:\www\apache\htdocs\test\index.php on line 79
Cannot connect to the database

when I make my sql statement as:

SELECT * FROM REQUEST ORDER BY Req_time DESC

My script works fine.

Any idea ?

Thanks

Lars_Berg

Limit is not a standard SQL feature, it is specific to Mysql and Postgres.

In MSSQL you can use the top keyword (which works in MSSQL and Access only).

SELECT top 10 * FROM REQUEST ORDER BY Req_time DESC

Zajil

Thanks, that is work for me but I have one more question: Is it possible to view for example records from 10 to 20 ?

Regards,,

Lars_Berg

To get rows 10-20 from a result use

select top 10 * from t where id not in (select top 10 * from t order by id) order by id

It is not efficient but it is the best you can do with SQL. Sometimes it is better to do paging with a client side mechanism or creating a temporary table with a sequence number.

Zajil

Thanks for your help 🙂

Higgie

How ich can select the rows 10-20 for example when i select more that one field?

my query:
SELECT top 2 FROM int_log where id not in (select top 2 from int_log)

But this is only 4 one field and i want to select a whole row!
plz help

Higgie

oh i have it... a littel mistake... thx a lot without your description i never done it 🙂