Make smilies using str_replace and MySQL?

[website]

it echoes the columns you selected, in the order you selected them...

edit: heh fast replies

[vien]

Thanks Samsm!;
i perfectly Understand now!

$row[0] would contain the first row column in the select, $row[1] the second, [2] the third... etc...

Read the comments on these echos:

$sql = "select foo, bar from sampleTable"
$row = mysql_fetch_row($sql);
echo $row[0]; // this works (echos foo)
echo $row[1]; // so does this (echos bar) 

[Hartmann]

This may be a little late but I posted something about this a while back. The thread can be found here -> http://www.sitepointforums.com/showt...threadid=98714

[ASLICEOFPIE]

Hi, I'm really new here and I was just viewing this post. I still don't get how this whole thing works, and I really want to be able to replace : ) with on my site. Could you please explain this to me?

[samsm]

Hi, I'm really new here and I was just viewing this post. I still don't get how this whole thing works, and I really want to be able to replace : ) with :) on my site. Could you please explain this to me?

If it is just that one smilie:

$text = str_replace(':)','<img src="/path/to/happy.gif" alt=":)" />', $text); 

Hope that's right. :-)

If you need anything more elaborate, I might suggest starting a new thread, this one is a bit old and people might not scroll down enough to notice your questions.