In on submit after email I put a code in which tells the subscriber if he was the first, second etc subsciber
This works fine, but I also would like to have this in an email templates as well
Hope there is a way to do so
This is the code
This works fine, but I also would like to have this in an email templates as well
Hope there is a way to do so
This is the code
<?
$db =& JFactory::getDBO();
$sql = "SELECT * FROM jos_chronoforms_MYFORM";
$number = mysql_query($sql);
$number_rows = mysql_num_rows($number);
$total = $number_rows + 1;
?>
<p>
You are nr. <? echo $total; ?> who subitted the form.
</p>