I tried to redirect my form to a specified url when the sum of the column 'aantal' of all records reaches a certain amount (e.g. 15).
I tried to put this code in a custom code action in the 'On load' action but this doesn't work:
I tried to put this code in a custom code action in the 'On load' action but this doesn't work:
<?php
$db =& JFactory::getDBO();
$query = "
SELECT *
FROM `#__my_table` ;
";
$db->setQuery($query);
$aantal = mysql_fetch_array(mysql_query("SELECT SUM(aantal) FROM #__my_table"));
if ( $aantal >= 15 ) {
// Redirect to my url
$app =& JFactory::getApplication();
$app->redirect('myurl');
}
?>