shows warning that suplied argument is not a valid

jam

New Member
while performing inner join when i add data in mysql it shows a error mysql_fetch_array is not a valid argument. code is below:\[code\] echo $sql="SELECT * FROM info INNER JOIN item ON info.info_id=item.info_id where item.info_id=".$info_id; $query=mysql_query($sql); while($result=mysql_fetch_array($query)) { echo "<tr>"; echo "<td>" .$result['Name']. "</td>"; echo "<td>" .$result['Item']. "</td>"; echo "<td>" .$result['Price']. "</td>"; echo "<td>" .$result['info_id']. "</td>"; echo "<td><a href='http://stackoverflow.com/questions/15876997/item.php?act=edit&id=".$result['id']."'>Edit</a></td>"; echo "<td><a href='http://stackoverflow.com/questions/15876997/item.php?act=delete&id=".$result['id']."'>Delete</a></td>"; echo "<td><a href='http://stackoverflow.com/questions/15876997/item.php?act=item&id=".$result['id']."'>Item</a></td>";echo "</tr>";\[/code\]while running the above code it shows the following warning:warning:mysql_fetch_array(): supplied argument is not a valid MySQL result resourc
 
Back
Top