What wrong with: SELECT * FROM $tablename ORDER BY fieldNm LIMIT $recordsPerTime

[johnsmith153]

SELECT * FROM $tablename ORDER BY fieldName LIMIT 200

I want to select all records from a table, return in order of a set field, but only the first 200 records

[trq]

And the problem is?

[johnsmith153]

it doesn't work. I guess from your response it should work then?

[trq]

Providing $tablename is defined and fieldName exists, yes.

[johnsmith153]

 

Go to : http://www.w3schools.com/sql/sql_tryit.asp

 

...and enter the below statement in the test:

 

SELECT * FROM customers ORDER BY City LIMIT 5

 

It doesn't work.

[trq]

Thats because LIMIT is specific to mysql, there using some other sql database that doesn't support LIMIT.

[johnsmith153]

What would be the alternative? I.e. what would you use on that site?

[PHPNewbie55]

You may want to post more of your code so that we can see more than just the one line...

Because that one line should work providing that there isn't another issue within your code...

Just a thought...

[johnsmith153]

Here's your answer:

 

 

 

 

 

 

SELECT TOP 5 * FROM $table ORDER BY $field

[Malevolence]

*considerably flaming (sorry)*

 

oh dear...

 

*fixing that*

 

You really should always post relevant php code such as the queries, defined variables etc. and any errors you recieved.

That way people can help you a lot easier and you don't find yourself having to explain the problem at best.