IN clause

If I have a SQL statement using the IN clause, how do I keep the order
of the list?

Example:
SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))

How would I pull records in the order of the numbers to list out as:
5 - Record 5
9 - Record 9
3 - Record 3
4 - Record 4
1 - Record 1
7 - Record 7
2 - Record 2
8 - Record 8
6 - Record 6

Thanks so much...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: IN clause

By the way, I want the numbers to list out in the order I have them in
the statement, not numerically and not randomly like it does now.

Thanks...

Bryan wrote:
> If I have a SQL statement using the IN clause, how do I keep the order
> of the list?
>
> Example:
> SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))
>
> How would I pull records in the order of the numbers to list out as:
> 5 - Record 5
> 9 - Record 9
> 3 - Record 3
> 4 - Record 4
> 1 - Record 1
> 7 - Record 7
> 2 - Record 2
> 8 - Record 8
> 6 - Record 6
>
> Thanks so much...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: IN clause

Thanks to Benno Rem for pointing out the ORDER BY FIELD(..) that one can
use in MySQL. Now to find a way to use it in MSSQL 2000. Wrong group for
that I guess. 8-O

Bryan wrote:
> By the way, I want the numbers to list out in the order I have them in
> the statement, not numerically and not randomly like it does now.
>
> Thanks...
>
> Bryan wrote:
>> If I have a SQL statement using the IN clause, how do I keep the order
>> of the list?
>>
>> Example:
>> SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))
>>
>> How would I pull records in the order of the numbers to list out as:
>> 5 - Record 5
>> 9 - Record 9
>> 3 - Record 3
>> 4 - Record 4
>> 1 - Record 1
>> 7 - Record 7
>> 2 - Record 2
>> 8 - Record 8
>> 6 - Record 6
>>
>> Thanks so much...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: IN clause

u can use array

put all your data into array.. example below


while($tmp=mysql_fetch_array($res)){
$myData[$tmp[0]]=$tmp[1];

}

ksort($myData);

foreach($myData as $nm=>$val){
//put your script here..

}
----- Original Message -----
From: "Bryan"
To:
Sent: Tuesday, June 26, 2007 8:01 PM
Subject: [PHP-DB] IN clause


> If I have a SQL statement using the IN clause, how do I
keep the order
> of the list?
>
> Example:
> SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2,
8, 6))
>
> How would I pull records in the order of the numbers to
list out as:
> 5 - Record 5
> 9 - Record 9
> 3 - Record 3
> 4 - Record 4
> 1 - Record 1
> 7 - Record 7
> 2 - Record 2
> 8 - Record 8
> 6 - Record 6
>
> Thanks so much...
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: IN clause

Bryan wrote:
> If I have a SQL statement using the IN clause, how do I keep the order
> of the list?
>
> Example:
> SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))

Try

SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6)) ORDER
BY 5, 9, 3, 4, 1, 7, 2, 8, 6;

No idea if that will work ;)

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php