Show 3 Latest Announcements?

[tommyquang]

Anyone know how can I show 3 latest announcements on portal home?

[bear]

http://wiki.whmcs.com/Linking_to_WHMCS#Showing_Announcements_on_your_Site

[tommyquang]

Thanks for the link, but I want to show 3 latest announcements on the portal home page, not on my website.

[bear]

Have you tried that? What happens when you do?

You may not need the first two lines and the opening and closing PHP tags, or you could try inserting the full block with {PHP}{/PHP} if you're getting smarty errors.

[chrismfz]

<?php
$query = "SELECT * from tblannouncements WHERE published='on' ORDER BY
date DESC";
$result=mysql_query($query);
$num=0;
while($data = mysql_fetch_array($result) and $num<3  ) {
$num = $num +1;

$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);

echo("$date <br />");
echo(" - <b>$title</b> -<br />");
echo("$announcement");
echo('<br />___________________________<br />');

}
?>

 

You can insert this code in template using {php} tags or simpler,

create a file like announcements.php paste the code there, make any changes

you want with the format (font, color, css, etc) and then just include the file

using {php}include announcements.php{/php}

[kits]

Below code are use with smarty and SEF urls. Hopefuly englighten who ever stucked with $announcements loop.

 

{if $announcements}
<div class="latest_news">
{foreach from=$announcements item=announcement name=foo}
 {if $smarty.foreach.foo.index < 3}
    <div class="n_date">{$announcement.date}</div>
    <div class="n_tite"><a href="{if $seofriendlyurls}announcements/{$announcement.id}/{$announcement.urlfriendlytitle}.html{else}announcements.php?id={$announcement.id}{/if}">{$announcement.title}</a></div>
    <div class="n_para">{$announcement.text|strip_tags|truncate:100:"..."}</div>
    <div class="n_rear"><a href="{if $seofriendlyurls}announcements/{$announcement.id}/{$announcement.urlfriendlytitle}.html{else}announcements.php?id={$announcement.id}{/if}"">read more</a></div>
  {/if}
{/foreach}
{/if}

 

you can use index to control the loop condition.

 

  {if $smarty.foreach.foo.index < 3}

means you will get 3 latest announcements.