markb
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: How do I not display child page on Index page?Thanks very much, although I’m not sure if that’s the answer I need tomhanna….
You know, regardless of what category you post a new entry in, it displays on the index page right?
Now what I want, is to add posts to the category ‘fractal interpretations’, without displaying the posts from that category on the index page.. know what I mean?
Is this possible?
Forum: Fixing WordPress
In reply to: Database Comment_Approved Errornevermind.. i switched to classic and then back to my theme and it cleared the problem.. (whatever it was)
it seemed to happen after i put in the ‘recent comments’ include…
do you know of an include that works well for this?? do i actually have to install it or is it just a matter of pasting in the include??
Forum: Fixing WordPress
In reply to: Database Comment_Approved Errorthat seems to work.. my posts now display.. what does that mean?
Forum: Fixing WordPress
In reply to: Database Comment_Approved Errorthe error message i get on my actual blog seems to point to this line of code:
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = $id AND comment_approved = '1' ORDER BY comment_date");
is that line as it should be??
Forum: Fixing WordPress
In reply to: Database Comment_Approved Errori never added it as a ‘plugin’ as such, i just added the include… so the plug in doesn’t show up..
Forum: Fixing WordPress
In reply to: Database Comment_Approved Error
$posts = get_posts('numberposts=5&offset=1&category=1');
foreach($posts as $post) :
?>
<li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li>
<?php endforeach; ?>
Forum: Fixing WordPress
In reply to: Database Comment_Approved Error$posts = get_posts(‘numberposts=5&offset=1&category=1’);
foreach($posts as $post) :
?>- “><?php the_title(); ?>
<?php endforeach; ?>
**sorry removed the link **
Forum: Fixing WordPress
In reply to: Database Comment_Approved Errori’ve removed the include but the problem remains… 🙁 i’m thinking maybe it made a change 2 the db and even once removed it still makes problems?? the include is as follows:
<?php
$posts = get_posts(‘numberposts=5&offset=1&category=1’);
foreach($posts as $post) :
?>- “><?php the_title(); ?>
<?php endforeach; ?>
Forum: Fixing WordPress
In reply to: Database Comment_Approved ErrorI have the same problem!! 🙁
I had just added an include that gets the recent posts… all of a sudden, every post on my site now says:
WordPress database 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 comment_approved = ‘1” at line 1]
SELECT COUNT(comment_ID) FROM yl_comments WHERE comment_post_ID = AND comment_approved = ‘1’;I’d appreciate help as soon as possible.. regards