Problems with queries

Emmash

Hi,

I have a query like :

SELECT no_document,titre_document FROM document WHERE no_document=3 OR no_document=1 OR no_document=2

and I have a loop like :

while($ligne=mysql_fetch_array($requete)){
...
}

When I display the results in the loop, I get document 1, document 2 and document 3 displayed instead of document 3, document 1 and document 2 like in my where clause.

Is there a way to keep the order like the order in the WHERE clause because my results always seems to re-order automatically by id...

Thanks to help me!!!

Marie-Hélène

devinemke

SELECT no_document, titre_document FROM document WHERE no_document IN(1,2,3) ORDER BY no_document DESC

laserlight

hmm... devinemke's query is better, but it still will not meet your requirements. If no ORDER BY clause is used, the ordering is implementation defined. Here an ORDER BY clause is used, but it will order in descending order, whereas you require an unusual ordering.

I believe that there are ways to tweak this ordering in SQL itself, but I am guessing that you actually want to allow your users to specify some custom order and order by that instead. One way to do this is to introduce a separate column to specify the order, and then order by that. You would need to incorporate this into a form such that your users can set the order at will.

Emmash

I found the solution by reading in MYSQL Documentation.... Here is the solution :

SELECT no_document,titre_document FROM document WHERE no_document=3 OR no_document=1 OR no_document=2 ORDER BY FIELD(no_document,'3','1','2')

djjjozsi

Let's create a field, for an order of your table. The default value will 0, and you easily could set the order you want to show.
"SELECT * FROM table WHERE field IN (1,2,3) ORDER BY order_field";

hella!

Emmash;10890596 wrote:
I found the solution by reading in MYSQL Documentation.... Here is the solution :

SELECT no_document,titre_document FROM document WHERE no_document=3 OR no_document=1 OR no_document=2 ORDER BY FIELD(no_document,'3','1','2')