Jump to content

MySQL Syntax Error!


lpxxfaintxx

Recommended Posts

[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.' at line 7]

 

SELECT DISTINCT ID, post_title, post_date, wp_terms.term_id as post_category FROM wp_posts, wp_terms, wp_term_relationships, wp_term_taxonomy WHERE wp_terms.term_id = AND wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_term_taxonomy.term_id = wp_terms.term_id AND ID != 500 AND post_status = 'publish' ORDER BY post_date DESC LIMIT 400

 

Any idea what's wrong?

Link to comment
https://forums.phpfreaks.com/topic/78696-mysql-syntax-error/
Share on other sites

Does this help?

 

$category_check = " WHERE {$tp}terms.term_id = " . $c->cat_ID . " ";

 

$last_posts = (array)$wpdb->get_results("

SELECT DISTINCT ID,

post_title,

post_date,

{$tp}terms.term_id as post_category

FROM {$tp}posts, {$tp}terms, {$tp}term_relationships, {$tp}term_taxonomy

{$category_check}

AND {$tp}posts.ID = {$tp}term_relationships.object_id

AND {$tp}term_relationships.term_taxonomy_id = {$tp}term_taxonomy.term_taxonomy_id

AND {$tp}term_taxonomy.term_id = {$tp}terms.term_id

{$ddop_inc_current}

AND post_status = 'publish'

ORDER BY post_date {$newest_check}

LIMIT {$ddop_num}

Link to comment
https://forums.phpfreaks.com/topic/78696-mysql-syntax-error/#findComment-398275
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.