[resolved] MySQL Syntax Error!

lpxxfaintxx · 11-24-2007, 02:06 PM

[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

This is the full query:

$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}

Any idea what's wrong?

-NC- · 11-24-2007, 02:41 PM

Quote:

wp_terms.term_id = AND

equals AND?

$c->cat_ID is returning nada

Peter · 11-24-2007, 02:44 PM

Yes -NC- has pinpointed your problem. $c->cat_ID is not producing anything so wp_terms.term_id is not being compared to anything.

lpxxfaintxx · 11-24-2007, 03:27 PM

Ah! Any Wordpress/MySQL guru's want to help me get this figured out?

**Eric** · 11-24-2007, 08:05 PM

What WP version are you using?

-NC- · 11-24-2007, 08:14 PM

rough hack off the top of my head:

if( is_numeric( $c->cat_ID ) ) {
$category_check = " WHERE {$tp}terms.term_id = " . $c->cat_ID . " ";
}else{
$category_check = " WHERE 1=1 ";
}

11-24-2007, 02:06 PM	#1 (permalink)
lpxxfaintxx Senior Member Join Date: May 2006 Location: Irvine, CA Posts: 1,060 261.85 NP$ (Donate)	MySQL Syntax Error! [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 This is the full query: $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} Any idea what's wrong? __________________ han(sup) yoon - internet entrepreneur

11-24-2007, 02:44 PM	#3 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	Yes -NC- has pinpointed your problem. $c->cat_ID is not producing anything so wp_terms.term_id is not being compared to anything. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-24-2007, 03:27 PM	#4 (permalink)
lpxxfaintxx Senior Member Join Date: May 2006 Location: Irvine, CA Posts: 1,060 261.85 NP$ (Donate)	Ah! Any Wordpress/MySQL guru's want to help me get this figured out? __________________ han(sup) yoon - internet entrepreneur

11-24-2007, 08:05 PM	#5 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	What WP version are you using? __________________

11-24-2007, 08:14 PM	#6 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	rough hack off the top of my head: if( is_numeric( $c->cat_ID ) ) { $category_check = " WHERE {$tp}terms.term_id = " . $c->cat_ID . " "; }else{ $category_check = " WHERE 1=1 "; } __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Technical Services