Here is the evil query: SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR (post_content LIKE '%%')) AND post_date < '2002-08-31 14:31:55' AND post_category > 0 ORDER BY post_date DESC
Here's a structure dump of the table it's trying to select from: CREATE TABLE b2comments ( comment_ID int(11) unsigned NOT NULL auto_increment, comment_post_ID int(11) NOT NULL default '0', comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default '', comment_author_url varchar(100) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default '', comment_date datetime NOT NULL default '0000-00-00 00:00:00', comment_content text NOT NULL, comment_karma int(11) NOT NULL default '0', PRIMARY KEY (comment_ID) ) TYPE=MyISAM; This is my first time posting to the list, so do you need any more information? I'll be happy to provide any other information needed, PHP or SQL code, etcetera. --Matt --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
