creating an array from Mysql database

[unistake]

I am trying to create an array from a mysql result.

At the moment I use the code below and the result turns out to be...

Array

Array

Array

Array

for the number of users.

 

Can anyone spot my problem?

<?php

include("../dbinfo.inc.php");

$cxn = mysqli_connect($host,$username,$password,$database) 
or die ("Couldn't connect to server."); 

$game="Chelsea V Liverpool";
$query  = "SELECT user FROM history WHERE game='$game'";
$result = mysqli_query($cxn,$query)
            or die ("Couldn't execute query.");

while($row = mysqli_fetch_assoc($result)) /// Take all the results
{
$user[]= $row['user'];

echo "$user<br>";
}
?>

 

Thanks

[luca200]

Not clear what you're trying to do, but for sure

echo "$row[user]<br>";

instead of

echo "$user<br>";

could work better

[unistake]

Ah! I have done that but put it in like this..

 

 

echo "{$row['user']}"; and it has worked!

 

thanks for the tip.

 

 

do you know why i could not echo the original? It seems the same to me - I am a newbie to PHP!

[unistake]

I am using this code so that I can send an email to all the users that is associated with the query.

 

Does anyone know how i can send out emails to them all?

 

such as        @mail({$row['email']},$subject,$text);

 

thanks

[trq]

<?php

include("../dbinfo.inc.php");

$cxn = mysqli_connect($host,$username,$password,$database) or die ("Couldn't connect to server."); 

$game="Chelsea V Liverpool";
$query  = "SELECT user FROM history WHERE game='$game'";
if ($result = mysqli_query($cxn,$query)) {
  if (mysqli_num_rows($result)) {
    while ($row = mysqli_fetch_assoc($result)) {
      mail($row['email'],$subject,$text);
    }
  }
}

?>