[bbDev] tag error fixed up

[Luc Saint-Elie]

Brian,

As far as I have tested bbpress requires Mysql 4.x

Luc

On 5/4/05, Brian Crouch <dr.brian.crouch at gmail.com> wrote:
> I fixed my obvious tag error with this change (the original 2005-05-04
> code is commented out):
> 
> function get_topic_tags ( $topic_id ) {
>         global $topic_tag_cache, $bbdb;
> 
>         if ( isset ($topic_tag_cache[$topic_id] ) )
>                 return $topic_tag_cache[$topic_id];
> 
>         /*$topic_tag_cache[$topic_id] = $bbdb->get_results("SELECT *
> FROM $bbdb->tagged JOIN $bbdb->tags ON ($bbdb->tags.tag_id =
> $bbdb->tagged.tag_id) WHERE topic_id = '$topic_id'");*/
> 
>         $topic_tag_cache[$topic_id] = $bbdb->get_results("SELECT *
> FROM $bbdb->tagged,$bbdb->tags WHERE $bbdb->tags.tag_id =
> $bbdb->tagged.tag_id AND topic_id = '$topic_id'");
> 
>         return $topic_tag_cache[$topic_id];
> }
> 
> I don't know if any of you where getting errors... but mine was
> barfing up some. It was the JOIN ... ON ... WHERE clause.
> 
> I got MySQL 3.23.58 for reference.
> 
> --
> Brian