mojolocollc

Sorry, forgot to code my code…

<a href="<?php next_posts_link() ?>"> <?php the_content(); ?> </a>

Sorry….we’ll also need the page ID for each post.

yeah, i googled it and had just pegged it as you responded. that fixed the error, and it’s working….thanks a bunch for your help!

ok, after debugging, I’m getting this:

Table ‘mojoblog_wordpress.term_relationships’ doesn’t exist

I understand what it’s saying, but I have no idea how to fix it. I’M SO CLOSE!!!!! I’m assuming I have to reference the taxonomy table somewhere…..right?

thank you for the input….and patience. I know enough about php to be quite dangerous, it seems. I wish there was more specific info on the boards about this specific issue…..

ok, so anyway, in your line of code above, i changed “$category_id” to “4” since 4 is the id of the category I want to limit the results to. The rest of your snippet I left as-is.

I uploaded, and now I get the following error:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/mojoloco/public_html/blogtest.php on line 15

If I take your snippet out, then it works (just without listing results from that specific category- it lists the 3 most recent results from all categories).

Any ideas?

does this display the title, date, and excerpt from a specific category? that’s what I’m trying to do, but haven’t had any luck finding a way to do it….see my post here…

I did search….and I saw that post. But it doesn’t solve my issue of needing to display recent posts from a SPECIFIC CATEGORY. That is the source of my issue.

Ok, we’re getting there, I think….still not working, though… In my code, i have:

$query = "Select * FROM wp_posts WHERE post_type='post' AND post_status='publish' AND ID IN (SELECT object_id FROM term_relationships WHERE term_id $category_id) ORDER BY id DESC LIMIT 3";

It’s bombing out…do I have your code in there correctly? please forgive my ignorance here….

thanks!

nevermind, fixed it. i’m a goof.

already found it….thanks for your help. resolved.

Yes, that’s it…..perfect. Thank you.
I’ve been using WP for about 24 hours, so the learning is slight…but not terrible.

Is there a similar function for get_archives? I don’t see it in classes.php.

Ok, maybe I’m not being clear in my question-

When I view the source of the page in my browser, it shows:

<li class=”cat-item cat-item-4″>Category Name (2)

My question is where is it getting the class=cat-item cat-item 4? It’s not in my style sheet, and it’s not on the template. Manipulating the code in deprecated.php doesn’t really help.

So, obviously, the script is generating this from SOMEWHERE…..if I knew where, I could change it. I just don’t know where to find it. And, the documentation on it is a little fuzzy.

Does that help at all?

there has to be a way to control that somewhere. I’m looking at <?php $categories = get_categories(parameters); ?>

That displays the list using my css class….BUT it adds a “category” heading to the list, which i don’t need. I don’t see a way to remove this….

getting closer, i think….

that’s it…thanks much….