Welcome Guest, Not a member yet? Register   Sign In
Can't retrieve all records from database [SOLVED]
#2

[eluser]andrewtheandroid[/eluser]
hey i'm not the most experienced when it comes to joins but ill give it a go.


have you tried doing a manual statement? like
Code:
$sql = 'SELECT * FROM items i, subcategories s WHERE s.cat_ID = items.item_ID';
$this->db->query($sql);

and is that "subcategories" meant to be "categories" in ur code or vise versa..


Messages In This Thread
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 08:51 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:04 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:25 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:39 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:56 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:57 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 10:00 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 10:01 AM



Theme © iAndrew 2016 - Forum software by © MyBB