KenKinoti
-
Posts
1 -
Joined
-
Last visited
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.
Error: Resource id #97 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in /var/www/Joomla_Version_Control/components/com
in PHP Coding Help
Posted
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>