<?php
mysql_connect("localhost","root","123123123");
mysql_select_db("acbc");
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
function get_silah_isim( $id ) {
        
    $res = mysql_query("SELECT * FROM `cu_arms_dealer_list` WHERE `armsId`=$id");
    while( $row = mysql_fetch_array($res) ) {
        $str = $row[armsTitle];
    }

    return $str;
}  
$u="1846001143";
$res = mysql_query("SELECT * FROM `cu_arms_log` WHERE `userid`=$u ORDER BY RAND() LIMIT 0,5");

$str .= 'Silahların : ';
while( $row = mysql_fetch_array($res) ) {
   $silah_id = $row[armsid]; 
   $silah_isim = $row[armsisim];

    if( empty($silah_id) ) {
       $str .= 'Silah yok.';
    }
    else {
        $silah_isim = get_silah_isim($silah_id);
        $str .= $silah_isim .',';
     }
}
echo $str;      
?>

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `cu_arms_dealer_list` (
  `armsId` int(10) NOT NULL auto_increment,
  `armsImage` text NOT NULL,
  `armsTitle` text NOT NULL,
  `armsPrice` int(10) NOT NULL default '0',
  `armsAmount` int(10) NOT NULL default '0',
  `armsAttack` int(10) NOT NULL default '0',
  `armsDefense` int(10) NOT NULL default '0',
  `armsLevel` int(10) NOT NULL default '0',
  `armsType` int(10) NOT NULL default '0',
  `armsSira` varchar(11) NOT NULL default '0',
  PRIMARY KEY  (`armsId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

INSERT INTO `cu_arms_dealer_list` VALUES (17, 'bicak.png', 'Biçak', 0, 0, 0, 0, 0, 0, '0');
INSERT INTO `cu_arms_dealer_list` VALUES (18, 'levye.png', 'Levye', 0, 0, 0, 0, 0, 0, '0');
CREATE TABLE `cu_arms_log` (
  `lid` int(10) NOT NULL auto_increment,
  `userid` int(10) default NULL,
  `armsid` int(10) default NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

INSERT INTO `cu_arms_log` VALUES (42, 1846001143, 17);
INSERT INTO `cu_arms_log` VALUES (43, 1846001143, 18);