[SOLVED] QUERY withour ORDER

[crashmaster]

Hi there,

 

have 1 problem.

 

For.ex:

 

I have a $str = '11,23,5,15';

 

I use this $str in mysql SQL query:

 

mysql_query("
        SELECT
            *
        FROM
            tab_table
        WHERE
            id IN (".$str.")
    ");

 

but when I am echoing results, results are ordered by id asc (5,11,15,23)... Hot to make query like this without reordering IDs ??? I need ID order like in $str

 

Thank you for any help or suggestion

[trq]

mysql_query("
        SELECT
            *
        FROM
            tab_table
        WHERE
            id IN (".$str.") ORDER BY id
    ");

[crashmaster]

mysql_query("
        SELECT
            *
        FROM
            tab_table
        WHERE
            id IN (".$str.") ORDER BY id
    ");

 

without result...doesnt work.

[Maq]

Try this and tell me if there is any errors:

 

mysql_query("SELECT * FROM tab_table WHERE id IN (".$str.") ORDER BY id") or die(mysql_error());

[trq]

Actually, having re-read the question.

 

mysql_query("
        SELECT
            *
        FROM
            tab_table
        WHERE
            id IN ($str) ORDER BY FIELD(id,$str);
    ");

 

should do it.

[crashmaster]

Try this and tell me if there is any errors:

 

mysql_query("SELECT * FROM tab_table WHERE id IN (".$str.") ORDER BY id") or die(mysql_error());

 

without any error.. Query accepted by sql engine without any problem.. by order is stil "BY id ASC" .. ((

[crashmaster]

Actually, having re-read the question.

 

mysql_query("
        SELECT
            *
        FROM
            tab_table
        WHERE
            id IN ($str) ORDER BY FIELD(id,$str);
    ");

 

should do it.

 

Works !! Thx a lot )