table equipment
id int(2), name varchar(64), property1 varchar(200), property2 varchar(200), pic varchar(64);
Код:
$select = (count($objects) > 1) ? implode(" OR name=", $objects) : $objects[0];
$sql = "SELECT name,property1,property2,pic FROM equipment WHERE name = $select";
$result = mysql_query($sql) or die(mysql_error());
$i = 0;
while($row = mysql_fetch_row($result))
{
$equipment[$i]['name'] = ($row[0]) ? $row[0] : 'untitled';
$equipment[$i]['pic'] = ($row[3]) ? $row[3] : 'unknown.gif';
$equipment[$i]['property1'] = $row[1];
$equipment[$i]['property2'] = $row[2];
$i++;
}
unset($i);
foreach($equipment as $piece)
{
echo $piece['name'].'<br>';
echo '<img src="/images/equipment/'.$piece['pic'].'"><br><br>';
}