How can I show the number of promo coupons remaining?

[Mr George]

With limited usage promo codes, is there a way to call the number of remaining coupons from WHMCS and display it on a web page?

[m00]

If the "web page" is on the same webspace as the WHMCS installation, you could try:

<?php
require("path/to/the/dbconnect.php"); // Path to WHMCS' dbconnect.php file

$result = mysql_query("SELECT (maxuses - uses) AS amount FROM tblpromotions WHERE id='1';"); // Define the ID of the promotion
$data 	= mysql_fetch_array($result);

echo "There are ".$data['amount']." spots left... (or something)";
?>

[Mr George]

Thanks - i'll give it a go...