having news from outside

[sinanata]

hi folks,

 

I'm the designer of tarmhost.com using whmcs and I made a small code snippet. If you are using whmcs like me. And want to have the announcements on your html site (outside of whmcs) you can use this small code and style it however you wany. Peace!

 

<?php

     $baglan = mysql_connect("yourhost/generaly localhost","your db user","users pass")||die("Mysql connection error");
     @mysql_select_db("your db name")||die("mysql connection error");


   $tablo="SELECT * FROM tblannouncements";
   $a=mysql_query($tablo);
   $maxeksibes=mysql_num_rows($a);



$sonuc = mysql_query(" SELECT * FROM `tblannouncements` ORDER BY `tblannouncements` . `date` DESC LIMIT 0, 5 ");





   	while ($satir = mysql_fetch_row($sonuc)) 
{


	if ( $satir[4]==on )

	echo 
	'		
<h1 class="news_heading">'.$satir[2].'</h1>
<p class="news_front">'.$satir[3].' /http://www.tarmhost.com/base/announcements.php"] devamı >> </p>



';


}

?>

[MACscr]

thanks, but i think this is like the 5 example of how to do this. =P

[sinanata]

no problem I just wanted to help. The moderator can delete if he want.

[MACscr]

btw, very nice job on that tarmhost.com, i really like the design.

[Adds]

Thanks for the code, but do I have to add any information to this or is it just a simple copy and paste code, how does it get the information from my WHMCS site?

 

Thanks,

Adam.

 

hi folks,

 

I'm the designer of tarmhost.com using whmcs and I made a small code snippet. If you are using whmcs like me. And want to have the announcements on your html site (outside of whmcs) you can use this small code and style it however you wany. Peace!

 

<?php

     $baglan = mysql_connect("yourhost/generaly localhost","your db user","users pass")||die("Mysql connection error");
     @mysql_select_db("your db name")||die("mysql connection error");


   $tablo="SELECT * FROM tblannouncements";
   $a=mysql_query($tablo);
   $maxeksibes=mysql_num_rows($a);



$sonuc = mysql_query(" SELECT * FROM `tblannouncements` ORDER BY `tblannouncements` . `date` DESC LIMIT 0, 5 ");





   	while ($satir = mysql_fetch_row($sonuc)) 
{


	if ( $satir[4]==on )

	echo 
	'		
<h1 class="news_heading">'.$satir[2].'</h1>
<p class="news_front">'.$satir[3].' /http://www.tarmhost.com/base/announcements.php"] devamı >> </p>



';


}

?>