我想更改mysql结果的格式...
[0] =>
[id] => 1
[name] => King
[1] =>
[id] => 5
[name] => Queen
采用这种格式:
[1] => King
[5] => Queen
但我不知道如何将mysql结果以这种格式显示。
$teamSql = "SELECT id, name FROM users WHERE projectid = '1';
$teamQuery = mysql_query($teamSql);
$teamFetch= mysql_fetch_assoc($teamQuery);
// and now?
最佳答案
$teamSql = "SELECT id, name FROM users WHERE projectid = '1'";
$teamQuery = mysql_query($teamSql);
$teams = array();
while ($team = mysql_fetch_array($teamQuery))
{
$teams[$team['id']] = $team['name'];
}
关于php - 使用id作为键,使用name作为数组的值,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/8758895/