latest topics for zenpage

quaker

I had a friend create this .. took him like 5mins to do it.

very simple...... he said.. LMAO..

Demo:http://256studio.com on sidebar..
Q

<div class="menu">
<h3>Latest News</h3>

<?php
$sql = 'SELECT title, titlelink FROM zp_zenpage_news WHERE `show`=1 ORDER BY date DESC LIMIT 5';
$result = query($sql);
while($latest_news = mysql_fetch_assoc($result)) {
echo '
• '.htmlspecialchars($latest_news['title']).'
';
}
?>

</div>

quaker

to get more listed please change the 5 to what every number you need.
from:
DESC LIMIT 5';
to:
DESC LIMIT 10';

Q

acrylian

And why didn't you just use the functions that are already there??

1. http://www.zenphoto.org/documentation/plugins/zenpage/_plugins---zenpage-template-functions.php.html#functiongetLatestNews
2. http://www.zenphoto.org/documentation/plugins/zenpage/_plugins---zenpage-template-functions.php.html#functionprintLatestNews
3. http://www.zenphoto.org/documentation/plugins/zenpage/_plugins---zenpage-functions.php.html#functiongetNewsArticles

quaker

i had a friend look at the docs and he did it that way..
if there is a cleaner way could someone post the code?

Q

acrylian

That's what I did above...

quaker

Why, When you echo getLatestNews() you end up with Array

Then if you use implode on it you get Array times 5?

What is the correct way to use this function?

acrylian

Because that function returns an multidimensional array. You need to use a forech loop and call the field to be echoed like in the example you posted above. Why don't you use printLatestNews()? That even prints a list as all the other functions in the sidebar.