Hi Bob,
As you may recall I have a custom code to count the nbr of subscribers.
But is it possible to pull this figure when a date is selected in the frontend?
This is teh HTML code
This is the Custom Code ( before e-mails)
Look forward hearing from you again,
Rgds
K
As you may recall I have a custom code to count the nbr of subscribers.
But is it possible to pull this figure when a date is selected in the frontend?
This is teh HTML code
<div class="ccms_form_element cfdiv_select" id="datum_container_div"><label for="datum">Wedstrijddatum</label><select size="1" id="datum" class="" title="Vul hier uw keuze in." name="datum">
<option value="27-10-2013">27-10-2013</option>
<option value="27-11-2013">27-11-2013</option>
<option value="27-12-2013">27-12-2013</option>
</select>
<div title="Wedstrijddatum" rel="Kies de gewenste datum!" class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-datum"></div></div>
This is the Custom Code ( before e-mails)
<?
$db =& JFactory::getDBO();
$pst = "SELECT COUNT(*) AS %s FROM %s
WHERE %s = %s";
$query = sprintf(
$pst,
$db->nameQuote('items'),
$db->nameQuote('J25_chronoforms_data_MYTABLE'),
$db->nameQuote('datum'),
$db->Quote(JRequest::getString('datum')));
$db->setQuery($query);
$result = $db->loadObject();
$total = $result->items+1;
$form->data['total'] = $total;
?>
Look forward hearing from you again,
Rgds
K