What does this error mean?
Posted: Sun Jun 12, 2005 2:43 pm
Code: Select all
Warning: mysql_result(): Bad column offset specified in /home/virtual/site65/fst/home/valornianvanguard/public_html/game/frames/profile.php on line 29Here's the associated code from code lines 22 to 42:
Code: Select all
$query1 = mysql_query("SELECT level, xp, name, inventory_id, c_class_lvl1, c_class_lvl2, c_class_lvl3, c_class_lvl4, deaths_today, dex, intel, str, con, cha, wis, attack, ac, attrib_pts_total, max_hp, max_mp, hp_left, mp_left, gold, class_skill_1, class_skill_2, class_skill_3, class_skill_lvl1, class_skill_lvl2, class_skill_lvl3 FROM characters WHERE name='$char' LIMIT 1", $conn) or die(mysql_error());
$char_info = mysql_fetch_array($query1);
$query2 = mysql_query("SELECT * FROM inventory WHERE id='$char_info[inventory_id]' LIMIT 1", $conn) or die(mysql_query());
$inv_info = mysql_fetch_array($query2);
foreach($inv_info as $inv_slot => $item_id) {
if(($inv_slot != 'id') && ($inv_slot != 'unequipped') && ($item_id != '')) {
line 26 $query3 = mysql_query("SELECT id, name FROM items WHERE id='$item_id'", $conn) or die(mysql_error());
$equipped_items[$inv_slot][name] = mysql_result($query3, 0, $inv_slot);
$equipped_items[$inv_slot][url] = "items.php?item_id=".$item_id;
} elseif(($inv_slot != 'id') && ($inv_slot != 'unequipped') && ($item_id == '')) {
$equipped_items[$inv_slot][name] = "No Item";
$equipped_items[$inv_slot][url] = "#";
} elseif(($inv_slot == 'unequipped') && ($item_id != '')) {
$unequipped_array = explode("--", $item_id);
foreach($unequipped_array as $u_item) {
$query4 = mysql_query("SELECT id, name FROM items WHERE id='$u_item'", $conn) or die(mysql_error());
$item = mysql_fetch_array($query4);
$unequipped .= "<tr><td class=\"profile_item\"><a href=\"items.php?item_id=$item[id]\">$item[name]</a></td></tr>\n";
}
}
}