Hi,
I have a table mysql, Now I need put field 1 of all rows in a array but I don't know how to put in. I really appreciate if you can assistance me. thanks
This is table linkauto
id link link_url
1 newyork museum http://www.abc.com/newyork_museum.html
3 newyork http://www.abc.com/newyork.html
4 newyork hotel http://www.abc.com/newyork_hotel.html
5 newyork tour http://www.abc.com/newyork_tour.html

I need a query to get auto field link as
$link= Array('newyork museum','newyork','newyork hotel','newyork tour')

Try this:

PHP Code:

$query = "SELECT link FROM `table`";
$result = mysql_query($query);
$num = mysql_num_rows($result);
for($i=0;$i<$num;$i++){
    $sql_arr = mysql_fetch_array($result);
    $link_arr[$i] = $sql_arr[0];
} 


PHP Code:

<?php 
$result = mysql_query($sql); 
for($rowset = array(); $row = mysql_fetch_array($result); $rowset[] = $row); 
?>