Извеждане на картинка от ДБ!

SuCcEsS

Registered
Как ще стане да изведа различна картинка за различна раса ето таблицата за расите!
Код:
CREATE TABLE settings (
  sID int(11) NOT NULL auto_increment,
  sName text NOT NULL,
  sValue text NOT NULL,
  sDesc text NOT NULL,
  rImage varchar(255) cp1251_bin NOT NULL,
  sGroup text NOT NULL,
  PRIMARY KEY  (sID)
) TYPE=MyISAM;
Това са расите:

Код:
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (57,'prace_1','Undead','Race Slot 1: Name','Race Settings');
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (58,'prace_2','Humans','Race Slot 2: Name','Race Settings');
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (59,'prace_3','Goblins','Race Slot 3: Name','Race Settings');
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (60,'prace_4','Elves','Race Slot 4: Name','Race Settings');
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (61,'prace_5','Orcs','Race Slot 5: Name','Race Settings');
INSERT INTO settings (sID, sName, sValue, sDesc, sGroup) VALUES (62,'prace_6','Dwarves','Race Slot 6: Name','Race Settings');
 
Код:
$res = mysql_query ("select * from `settings` order by `sID` desc") or die("opa");

while ($row = mysql_fetch_array($res))
{
	$image = $row['rImage'];
	$name = $row['sName'];
	echo "<img src=\"$image\" alt=\"\">".$name;
	
}
 

Back
Горе