from mysql to an array as a php variable ?

[ugurpc]

when i write strings inside of the following array my code works without any error.

$arr = array('news 1','news 2','news 3','news 4');
foreach ($arr as $new){
/* the rest of code works without problem */
}

What i want is that :

i have a simple mysql database with two fields "id" and "news".

I want to output the "news" coulumn results from sql and to input them as a variable instead of strings of array (line 1 at the above code) in a loop if possible.

Is this possible. If yes, pls tell me the way, i will be very happy and will solve my last 2 unanswered threads in this forum 🙂

[NogDog]

You can either run the query and the output the results while looping through the query results (e.g., see [man]mysql_fetch_assoc/man), or if you want to create an array to feed into your existing code, you can use the same function, but on each iteration of the fetch loop, add that result to an array, instead:

$result = mysql_query($query);
$arr = array();
while($row = mysql_fetch_assoc($result)) {
   $arr[] = $row['news'];
}