I have often wanted to do arbitrary 'ordering' from mysql query where the item looked for comes first.. and everything else then follows
so I wondered if I could do this
$sqlstring="SELECT from blah WHERE my_item_id = $itemid"
$result = mysql_query($sqlstring);
and then do a complimentary
$sqlstring2="SELECT from blah WHERE my_item_id != $itemid"
$result2 = mysql_query($sqlstring2);
and lastly combine $result and $result2 using an array operator
(and my 'while' statement will handle output without adjustment)
but it seems the mysql result is not an array - it appears to be a "Resource"
can I combine two mySql resources using this method?