Can't retrieve all records from database [SOLVED]

[eluser]andrewtheandroid[/eluser]
also can u describe what's in your categories table? since you are joining on cat_id = item_id.. i'm guessing there is a category that corresponds to each item? but then can't u just put that info into item?

or.. do you mean you have a category which many items belong to and u are trying to connect item into the category?

item.category = catagory.name ?

sorry if these sound like noob questions my sql isn't that fantastic haha