php数组在while循环中复制格式

Question

I want to output the result of a query so that the format is the same as:

$links = array(
'Link 1' => '/link1',
'Link 2' => '/link2'
);

So the query is

$query = "SELECT * FROM link";
$result = mysql_query($query, $connection) or die(mysql_error());
$row = mysql_fetch_assoc($result)

The field that need to be output are:

$row['link_title'] and $row['url']

Answer 1

This is probably a bit more complex then desired or necessary but would this work for you:

$a = 0;
while ($row = mysql_fetch_assoc($result)) {
    foreach ($row as $k => $v) {
        // Assumes table column name is 'link_title' for the link title
        if ($k == 'link_title') {$title[$a] = $v;} 
        // Assumes table column name is 'url' for the URL
        if ($k == 'url') {$url[$a] = $v;}
    }
    $a++;
}
$i = 0;
foreach ($title as $t) {
    $links[$t] = $url[$i];
    $i++;
}
print_r($links);

As @Class stated, if the link_title's never repeat than you could do something like this:

while ($row = mysql_fetch_assoc($result)) {
    $array[$row['link_title']] = $row['url'];
}

---

Since the link_title's were unique both processes output:

Array ( 
    [Moxiecode] => moxiecode.com 
    [Freshmeat] => freshmeat.com 
)

Database table + contents:

id | link_title |     url       |
---+------------+---------------|
1  | Moxiecode  | moxiecode.com |
---+------------+---------------|
2  | Freshmeat  | freshmeat.com |