Forums

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:

<?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');
}
?>

Works like a charm!
Thanks Bob!