displaying Array info from My SQL

Question

Hello i have tryed many ways to get this to work am unsure where my error is. i get the Error message.

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

This is the Code:

$dbh = mysqli_connect("HOST", $user_name, $password, $database_name);
if (!$dbh)
{
    die("Not connected : " . mysqli_error($dbh));
}

if ($method=="graces")
{ 
   $query = "SELECT id, name FROM raceslog";
    $userinfo = array();

      while ($row_user = mysql_fetch_assoc($query)){
       $userinfo[] = $row_user;}

       foreach ($userinfo as $user) {
         echo "^{$user[id]}"
            . "^{$user[name]}";
        }
 }

Well my question is does anyone see where my error is and could point me in the right direction to fix Thank You.

Explosion Pills · Accepted Answer · 2013-03-17 03:26:21Z

2

You need to actually run the query first with mysqli_query. Also note that mysql_* and mysqli_* are not compatible. You should stick with mysqli and properly parameterize your queries.

$result = mysqli_query($dbh, $query);
while ($row_user = mysqli_fetch_assoc($result)) {

You can also echo in the while loop if you want.

answered Mar 17, 2013 at 3:26

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

displaying Array info from My SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related