[qie]

hi, thanks friends......
it's works....
i've modified ....

thanks to nico_swd for:

str_replace(array_keys($smilies), array_values($smilies), $data[3]);

thanks to Wuiqed for:

//notice that I changed your mysql_num_rows() to mysql_fetch_array()
//this is because mysql_num_rows() only returns HOW MANY rows was
//fetched but doesn't return the actual rows

now the script like below:

PHP Code:

@mysql_pconnect('localhost','root','root');
@mysql_select_db('database');

$smilies = array(
    ':)' => '<img src="images/smile.gif" />', 
    ':(' => '<img src="images/sad.gif" />', 
    ';)' => '<img src="images/wink.gif" />'
);

$query = mysql_query("SELECT * FROM table");
while($data = mysql_fetch_array($query)) {
    $view.= "name: ".$data[1]."<br />";
    $view.= "subject: ".$data[2]."<br />";
    
    //;
    $view.= "message: ".str_replace(array_keys($smilies), array_values($smilies), $data[3])."<hr />";
}

echo $view;