Форумы портала PHP.SU

Не нашел категории "оптимизация", так что напишу тут.

Смысл проблемы в том, что в конфиг файле нужно создавать переменные - массивы с БД. Можно ли как то оптимизировать запрос?

PHP:
скопировать код в буфер обмена

 
//шлем
if($user['helm'] != 0)
{
        $helm = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[helm]' AND owner='$user[login]'"));
}
//Правая рука
if($user['rhand'] != 0)
{
        $rhand = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[rhand]' AND owner='$user[login]'"));
}
//Левая рука
if($user['lhand'] != 0)
{
        $lhand = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[lhand]' AND owner='$user[login]'"));
}
//Доспехи
if($user['arms'] != 0)
{
        $arms = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[arms]' AND owner='$user[login]'"));
}
//Ботинки
if($user['boots'] != 0)
{
        $boots = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[boots]' AND owner='$user[login]'"));
}
//плащь
if($user['coat'] != 0)
{
        $coat = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[coat]' AND owner='$user[login]'"));
}
//налечники
if($user['handss'] != 0)
{
        $handss = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[handss]' AND owner='$user[login]'"));
}
//Пояс
if($user['belt'] != 0)
{
        $belt = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[belt]' AND owner='$user[login]'"));
}
//амулет
if($user['amulet'] != 0)
{
        $amulet = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[amulet]' AND owner='$user[login]'"));
}
//медаль
if($user['medal'] != 0)
{
        $medal = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[medal]' AND owner='$user[login]'"));
}
//кольцо
if($user['ring'] != 0)
{
        $ring = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[ring]' AND owner='$user[login]'"));
}
//Книга
if($user['book'] != 0)
{
        $book = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[book]' AND owner='$user[login]'"));
}
//Свиток
if($user['roll'] != 0)
{
        $roll = mysql_fetch_array(mysql_query("SELECT * FROM inv WHERE id='$user[roll]' AND owner='$user[login]'"));
}
 

PHP.SU

PHP+MySQL