PHP mysql字段 数组

$sql = "SELECT key1,key2 FROM keyst"

$res = mysql_query($sql,$db_link)

$search = array()

$replace = array()

while($row = mysql_fetch_assoc($res)){

$search[] = $row['key1']

$replace[] = $row['key2']

}

$ftext = str_replace($search,$replace,$ftext)

试试这样行不行：

SELECT orderId,MAX(type) AS maxtype FROM table WHERE id IN (100,101,102) GROUP BY orderId

---