Confused

[thomashw]

Can anyone help me get this working? I'm doing a "tutorial" to create a shopping cart. This page is to actually display the contents of the cart, but I've not seen PHP coded like this before, and it's giving me an error saying "Fatal error: Call to a member function query() on a non-object."

 

<?
$id = intval($_GET['product_id']);
$total = 0;
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM feature_product WHERE feature_product_id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$title.' by '.$author.'</td>';
$output[] = '<td>£'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>£'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: £'.$total.'</p>';
?>

 

Thanks!

[duclet]

Where is $db being set? Use print_r on it to see if you are actually getting the correct object that should have the function query.

[revraz]

You are probably missing the Functions that go with it.

[thomashw]

I changed $result to equal mysql_query($sql). I used print_r and it's saying "Resource id #9."

[duclet]

No, I meant print_r on $db so that you can make sure it is actually an object that contains the method query.

[thomashw]

You are probably missing the Functions that go with it.

You're right, I was missing the functions. What a mess.