I don't plan to implement all of the wordpress_publish features.

The one thing am thinking about (that has been giving me problems cos am not receiving the connection right) may be the sql that card inserts and updates the values into 1. posts table 2. terms table 3. term_taxonomy 4 term relationship

tables whenever a publish is created.

$sql="update wp_posts set post_title='$name', post_name='$slug', post_content='$freeRTE_content', post_category='$category', post_status='$post_status', comment_status='$comment_status', mode_application='$howtoapply', website_address='$website', company_email='$email', application_deadline='$last_date', advert_date='$advert_date', post_date='$date', featured='$featured', course='$course', location='$location', grade='$grade' where id='$id'";
            if(mysql_query($sql, $link))
            {
                $expq=explode(',' , $q);foreach($expq as $key=>$value){$expq[$key]=trim($value);}$newq=join(',',$expq);
                $sql="insert into wp_term_relationships (term_taxonomy_id) select term_taxonomy_id from wp_term_taxonomy tt, wp_terms t where name in ('$newq') and taxonomy='post_tag' and t.term_id=tt.term_id";
                if(mysql_query($sql, $link))
                {
                    $sql="update wp_term_taxonomy tt, wp_terms t set count=count+1 where  name in ('$newq') and taxonomy='post_tag' and t.term_id=tt.term_id";
                    $result=mysql_query($sql, $link) or die(mysql_error($link));
                }

            }

        }

I'm not obtaining the relationship between your four tables right, please how do i fix this?

(please i'm not your wordpress atmosphere, but making use of wordpress structure)

I believe this is when my issue is:

$sql="insert into wp_term_relationships (term_taxonomy_id) select term_taxonomy_id from wp_term_taxonomy tt, wp_terms t where name in ('$newq') and taxonomy='post_tag' and t.term_id=tt.term_id";

the best factor to complete:

$sql="insert into wp_term_relationships (object_id, term_taxonomy_id) values ('my_post_id', 'the term taxonomy id')";

thanks all

You have:

in ('$newq')

According to your code, you are most likely winding up with the kind of:

in ('tag1,tag2,tag3')

As opposed to the needed and expected:

in ('tag1','tag2','tag3')