unistake Posted February 26, 2008 Share Posted February 26, 2008 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 More sharing options...
luca200 Posted February 27, 2008 Share Posted February 27, 2008 Not clear what you're trying to do, but for sure echo "$row[user]<br>"; instead of echo "$user<br>"; could work better Link to comment https://forums.phpfreaks.com/topic/93207-creating-an-array-from-mysql-database/#findComment-477597 Share on other sites More sharing options...
unistake Posted February 27, 2008 Author Share Posted February 27, 2008 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! Link to comment https://forums.phpfreaks.com/topic/93207-creating-an-array-from-mysql-database/#findComment-477632 Share on other sites More sharing options...
unistake Posted February 27, 2008 Author Share Posted February 27, 2008 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 Link to comment https://forums.phpfreaks.com/topic/93207-creating-an-array-from-mysql-database/#findComment-478377 Share on other sites More sharing options...
trq Posted February 28, 2008 Share Posted February 28, 2008 <?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); } } } ?> Link to comment https://forums.phpfreaks.com/topic/93207-creating-an-array-from-mysql-database/#findComment-478643 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.