oracle的一句关于数据库的语句，转成 mysql怎么写呢

[AlexJia2046]

$query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_time,m_available,m_salespeople,m_bz,id FROM zypt_mobile where m_sendshop='销售部' order by id,m_available";
ora_parse($cursor, $query) or die;
ora_exec($cursor);

$i=0;
while(ora_fetch($cursor)) {
$sms_yy[$i][0] = ora_getcolumn($cursor,0);
$sms_yy[$i][1] = ora_getcolumn($cursor,1);
$sms_yy[$i][2] = ora_getcolumn($cursor,2);
$sms_yy[$i][3] = ora_getcolumn($cursor,3);
$sms_yy[$i][4] = ora_getcolumn($cursor,4);
$sms_yy[$i][5] = ora_getcolumn($cursor,5);
$sms_yy[$i][6] = ora_getcolumn($cursor,6);
$sms_yy[$i][7] = ora_getcolumn($cursor,7);
$sms_yy[$i][8] = ora_getcolumn($cursor,8);
$sms_yy[$i][9] = ora_getcolumn($cursor,9);
$i++;
}
ora_close($cursor);
ora_logoff($handle);