Displaying Announcements on your Site

[Adds]

Hi,

Can anyone help me set this up? I want to display this on my site but I'm not sure what I have to place where?

WHMCS is installed at support.uk-hostingsolutions.co.uk so what do I need to put in here?

 

<?php

include("support/dbconnect.php");

include("support/includes/functions.php");

$query = "SELECT * FROM tblannouncements WHERE published='on' ORDER BY date DESC LIMIT 0,3";

$result = mysql_query($query);

while ($data = mysql_fetch_array($result)) {

$id = $data["id"];

$date = $data["date"];

$title = $data["title"];

$announcement = $data["announcement"];

$date = fromMySQLDate($date);

echo '<p><font color="#cccccc">'.$date.'</font> - <b>'.$title.'</b><br />'.$announcement.'</p>';

}

?>

[Adds]

Managed to get this to work apart from now it has a  before and after each announcement?

[laszlof]

var_dump($data); within the while loop and see if that actually exists in the database.

[Adds]

var_dump($data); within the while loop and see if that actually exists in the database.

 

Can you explain what I need to do here?

Thanks,

Adam.