Hi guys, I need your help. I have a blog and on a complete different page my homepage. Now what I want to do is that if I post a new post on my blog that the first 35 words of it appear in a layer, and then as well next to it the publish date. I realized that I would need to create an mysql query which comes up with the last entry, How can I do that? And then which is probably more complicated how can I tell mysql to give me just 35 words, or can I limit in any way the layer???? I am helpless! I would deeply appreciate if someone could help me! Thanks!
last blog entry, the basic syntax is:
select * from blog order by date desc LIMIT 1
for the 35 words i use:
SUBSTRING_INDEX(body, ' ', 35) as body
put those two together depending on your db structure.
