multiple table issue

[eluser]Clooner[/eluser]

Code:

$query = $this->db->query('SELECT carts.*, products.* FROM carts, products WHERE carts.product_id = products.id');

This is how you get the data, am I right? You select carts.* and products.* and both have an id? try changing the select statement to

Code:

SELECT carts.*, products.*, carts.id AS cart_id, products.id AS product_id

and then use cart_id instead of the id!