Error: Resource id #97 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in /var/www/Joomla_Version_Control/components/com

[KenKinoti]

Hi i know am kinda new to this but i keep getting this error above how do i resolve it

 

 

<?php
    //Get the database connection
    $db = JFactory::getDBO();
  //  if($filter == '');
    $query = "SELECT * FROM `com_versions`";
    $db->setQuery($query);
    $result1 = mysql_query($query);
    print_r ($result1);
    $getPosts = $db->LoadObjectList();
    $i=1;
?>
    <?php do{?>
    <tr>
      <td><?php echo $row_getPosts['i'];?></td>
      <td><?php echo $row_getPosts['id'];?></td>
      <td><?php echo $row_getPosts['client'];?></td>
      <td><?php echo $row_getPosts['url'];?></td>
      <td><?php echo $row_getPosts['software_name'];?></td>
      <td><?php echo $row_getPosts['dom'];?></td>
      <td><?php echo $row_getPosts['present_version'];?></td>
      <td><a href="?cmdEdit&id=<?php echo $row_getPosts['id'];?>">EDIT</a></td>
      <td><a href="?cmdDelete&id=<?php echo $row_getPosts['id'];?>">DELETE</a></td>
    </tr>
     <?php } while ($getPosts = mysql_fetch_assoc($query));?>
</table>

[trq]

The error is pretty self explanatory. You have passed a string ($query) to mysql_fetch_assoc, it expects a result resource ($result1).

 

Besides that, you should be doing a while loop, not  ado while. Your current approach makes little sense.