function url($url,$text=""){
$url=str_replace(array("<",">"),"",trim($url));
if(preg_match("/javascript(\:|\s)/i", $img) || empty($url)) return'<font size=2><i>Error: "'.$url.'" is invalid.</i></font>';
if($text=="")$text=$url;
return '<a href='.$url.'>'.$text.'</a>';
}
function bbReplace($string){
$string=preg_replace(
array('/\[center\](.*?)\[\/center\]/is','/\[right\](.*?)\[\/right\]/is','/\[youtube\](.*?)\[\/youtube\]/is'),
array('<center>$1</center>','<div style="align:right;">$1</div>','<object width="425" height="355"><param name="movie" value="http://www.youtube.com/v/$1"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/$1" type="application/x-shockwave-flash" wmode="transparent" width="425" height="355"></embed></object>'),
$string);
$string=preg_replace(
array('/\[url\=(.*?)\](.*?)\[\/url\]/ie','/\[email\](.*?)\[\/email\]/ie'),
array("url('$1','$2')","url('mailto:'.'$1','$1')"),
$string);
return $string;
}

[center]this is a test to see if the bbcodes are working[/center]

echo mysql_result($result,0,"post");

echo bbReplace(mysql_result($result,0,"post"));