array from table column result

[sevenfive]

i need to get an array from my db that contains all of the contents of a specific field. (not the row contents)

i cant find a php function that covers it as mysql_fetch_array only seems to return an array of the rows affected by a query...

any ideas?

many thanks

[LordShryku]

You mean all of the contents of a specific field, as it is in every row? You would just have to adjust your SQL statement to only select that field...

[sevenfive]

my query is SELECT field FROM tablename

how can i get an array from that?

[LordShryku]

$sql = "SELECT field FROM table";
$res = mysql_query($sql);
if(mysql_num_rows($res) > 0) {
   $array = array();
   while($r = mysql_fetch_array($res)) {
      $array[] = $r['field'];
   }
}

[sevenfive]

i cant get that to work...

this is the code in place...

$Link = mysql_connect ($Host, $User, $Password);

// create array from results


$sql="SELECT id FROM $TableName"; 

$res=mysql_db_query ($DBName, $sql, $Link);

if(mysql_num_rows($res) > 0) { 

$array = array(); 

while($r=mysql_fetch_array($res)) { 

$array[]=$r['id']; 

	} 

}


// pull three random rows from array

$rand_keys = array_rand($array, 3);

echo $input[$rand_keys[0]] . "\n";

echo $input[$rand_keys[1]] . "\n";

echo $input[$rand_keys[2]] . "\n";



mysql_close ($Link);

[LordShryku]

echo $input[$rand_keys[0]] . "\n";

$input should be $array....

[sevenfive]

my hero ;-)

what a fool... thanks for the help