 |
boardom b2 message board
|
View previous topic :: View next topic |
Author |
Message |
ajitdsa
Joined: 17 Oct 2003 Posts: 10 Location: Austin, TX
|
Posted: Fri Nov 14, 2003 11:20 pm Post subject: wanna pull latest post into page outside of blog |
|
|
ok, on our site:
http://www.fragilistics.com?reference=boardom2
we are using b2 for the news section. now i have a "hack" if you wanna call it that where i just query the mySQL database myself and get the latest post for the frontpage, but i'm wondering if there's a better way to do it.
can i just include some b2 files and then use b2 functionality to do this?
basically i have the root directory of my site:
/
and then my b2 blog in the blog directory off the root:
/blog/
and all of the b2 files are in there. (you can get to the blog by clicking the {news} link. if i could figure this out, then i wouldn't have to have a separate index.php file for the blog either. and that would rock.
thanks,
ajit |
|
Back to top |
|
 |
ajitdsa
Joined: 17 Oct 2003 Posts: 10 Location: Austin, TX
|
Posted: Sat Nov 15, 2003 3:50 am Post subject: select statement |
|
|
by the way, my SQL select statement was:
SELECT * FROM b2posts, b2users WHERE b2posts.post_author = b2users.ID ORDER BY b2posts.post_date DESC LIMIT 1 |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB 2 © 2001, 2002 phpBB Group
|