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

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']

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 |

Are you looking for something like this:

$links = array();
while(foo){
    $links[$row['link_title']] = $row['url'];
}

OR you can use which might cause overriding if the title is the same like in the example above

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

$links = array_combine($title, $link);

Also use PDO or mysqli functions mysql is deprecated. Here's a tutorial for PDO

EDIT: Example: http://codepad.viper-7.com/uKIMgp I don't know how to create a example with a db but its close enough.

You want to echo out the structure of the array?

foreach ($Array AS $Values => $Keys)
{
 echo "Array Key: <b>". $Keys ."</b>  Array Value:<b>". $Values ."</b>";
}

This will echo out the structure of your exampled array