Warning: mysql_fetch_assoc() expects parameter 1

Question

I'm trying to display info from all the users in the data base and it keeps giving me this error

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in /home/killerdu/public_html/userlist.php on line 30

Line 30

while($people=mysql_fetch_assoc($people_list)){

<?php
include 'core/int.php';
include 'includes/head.php';
include 'head.php';
include 'includes/body.php';
include 'body.php';

$people_list="SELECT * FROM users";

$people=mysql_query($people_list);

?>
<html>
<head>
</head>
<body>
<pre>
<table class="table table-bordered">
      <thead>
        <tr>
          <th>ID</th>
          <th>Username</th>
          <th>Email</th>
        </tr>

      <?php

     while($people=mysql_fetch_assoc($people_list)){ 
     echo "<tr>";
          echo "<td>". $people_list['user_id']."</td>";
          echo "<td>". $people_list['username']."</td>";
           echo "<td>". $people_list['email']."</td>";
        echo "</tr>";     
     }

      ?>
      </thead>
      </pre>
</body>
</html>

You mixed up your variables for `while($people=mysql_fetch_assoc($people_list))` switch them. `while($people_list=mysql_fetch_assoc($people))` — Funk Forty Niner, Sep 12 '14 at 00:58
@Fred-ii- Could you make that into a answer so i can mark it as answer also thanks ! — KillerDucky1, Sep 12 '14 at 01:01

score 3 · Accepted Answer · answered Sep 12 '14 at 01:02

3

As requested by the OP, comment to answer:

You mixed up your variables for while($people=mysql_fetch_assoc($people_list)) switch them. while($people_list=mysql_fetch_assoc($people))

answered Sep 12 '14 at 01:02

Funk Forty Niner

74,372
15
66
132

score 2 · Answer 2 · answered Sep 12 '14 at 00:57

2

You used $people=mysql_query($people_list);

So load it inside:

while($row=mysql_fetch_assoc($people)) {
                             // ^ load $people, the resource, not $people_list the string

You loaded the query string instead of the resource.

answered Sep 12 '14 at 00:57

Kevin

41,329
12
52
68

You should pass the connection resource to `mysql_query` and in this code it is not created. – Zini Sep 12 '14 at 00:58
@Zini well that remains to be seen, since the OP loaded a lot of includes – Kevin Sep 12 '14 at 00:59
@Ghost thanks for the help turns out i just mixed variables ! – KillerDucky1 Sep 12 '14 at 01:01
@KillerDucky1 yes just mixed up on the variables glad it helped – Kevin Sep 12 '14 at 01:03

Warning: mysql_fetch_assoc() expects parameter 1

2 Answers2