Hello,
I was working on a way to make so when I add a new Promotion Code in the WHMCS Admin panel it instantly updates on the main page with all the codes.
The Script is written in PHP by me I hope you like it
<?php
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
$result = mysql_query("SELECT * FROM tblpromotions")
or die(mysql_error());
echo "<table border='0' style='color: #FFF'>";
echo "<tr> <th>Promocode</th> <th>Discount</th> <th>Expiration</th> </tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr><td>";
echo $row['code'];
echo "</td><td>";
echo $row['value'];
echo $row['type'];
echo "</td><td>";
echo $row['expirationdate'];
echo "</td></tr>";
}
echo "</table>";
?>
-John
