Extract Data According To Preset Sequence... How?

wondering whether i can make this work...

first, i will make an array like this:

Quote:

$category_id[]="10,6,9,8,3";

then i wanna extract the information( category name, category id, and sub category into array and arrange them in the preset sequence in category_id[] above.

Quote:

$query="select * from category order by $category_id[] ";
$result="mysql_query($query) or die(mysql_error());

while ($row=mysql_fetch_assoc($result))
{
echo $row['category_id'];
echo $row['category_name'];
echo $row['subcategory'];
}

the output i wish to get is like this:

Quote:

1st result:
category id: 10
category name= the name of category 10
sub category=
sub 1 category 10
sub 2 category 10
sub 3 category 10

2nd result:
category id: 6
category name= the name of category 6
sub category=
sub 1 category 6
sub 2 category 6
sub 3 category 6

3rd result:
category id: 9
category name= the name of category 9
sub category=
sub 1 category 9
sub 2 category 9
sub 3 category 9

I'm confuse in the extraction info according to the preset sequence... can anyone please share some ideas? will this idea works?

• Inserting New Data Within A Structured Sequence
• Extract Data Into CSV
• Data Extract
• Extract Data
• How To Extract Only The Starting Data?
• Extract Partial Data
• Extract Data Using Joins
• Extract Data From Notepad
• Extract Data And Create Database:
• Extract Data And Create Database
• Most Efficient Way To Extract Limited Data
• How Do I Extract All My Text Data Input From A Php Forum?
• Extract 5 Digit Column Data Into Another Column
• Disrupted Sequence
• Create A Sequence?
• Sequence Substitute
• CREATE SEQUENCE ?
• Sequence Creation
• Sequence Generation
• What Collation Sequence?
• Identity, Sequence, Serial
• Re-arrange Primary Key Sequence
• Selcting Date Sequence
• Order By An (out Of Sequence) Set Of Numbers
• ALPHANUMERIC SEQUENCE IN 5.0 VERSION?
• How To Create A Sequence In MySQL
• Mysql Execution Sequence
• Find The Number Of A Row In A Sequence
• EXTRACT
• Bulk Insert Of New Records In Sequence
• How To Generate Sequence Values During Query
• Change The Sequence Of Column In Table
• Create Sequence Syntex Errors Out
• Extract, Transform
• Extract And Compare
• Extract Specified Part
• Extract First Sentence
• Extract Function
• Extract By Date
• How To Extract Id Of Inserted Row?
• Extract Date
• Max Sequence Number In Claim Transaction Table
• Generated Sequence # Based Upon Content Of Row Being Inserted
• Primary Key Field: Varchar(32) Versus Sequence
• Ordering By Sequence Field With Empty Values
• Index On Long Column And Auto Sequence In Mysql
• Extract Meta-informations