burnist
05-26-2004, 06:49 PM
$itemsquery = $DB_site->query("SELECT items.* FROM items LEFT JOIN items_users ON items.id=items_users.itemid
WHERE items_users.userid = $bbuserinfo[userid]");
while($item = $DB_site->fetch_array($itemquery)){
eval("\$inventorybit .= \"".fetch_template("inventory_bit")."\";");
}
This block of code is not showing its output, ifs its even producing any at all, Im still a newbi coder and this is my first time using a join of anykind so im kinda lost here, any help would be most appreciated :)
WHERE items_users.userid = $bbuserinfo[userid]");
while($item = $DB_site->fetch_array($itemquery)){
eval("\$inventorybit .= \"".fetch_template("inventory_bit")."\";");
}
This block of code is not showing its output, ifs its even producing any at all, Im still a newbi coder and this is my first time using a join of anykind so im kinda lost here, any help would be most appreciated :)