Jump to content

creating an array from Mysql database


unistake

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/93207-creating-an-array-from-mysql-database/
Share on other sites

<?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);
    }
  }
}

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.