I am building a page where I would like to have four drop-downs to filter down the data displayed from a particular section. The results from the first one would then populate the second one, the results from that one would populate the third one and so on. I'd like the drop-downs to change automatically upon selection. Can anyone point me in the direction of how I can achieve this?

Thanks

The information is being transferred from large CSV files where the data is already in this format - records with personal data and performance data combined.

Once this data has been transferred over, I'd like to be able to enter new performance data for an individual who already has a record without having to enter their personal data (ID, First Name, Last Name, DOB) again; but the option needs to remain to enter this information manually for new individuals, if that makes sense.

I'm just getting started with MySQL stuff. Is this something I can hire one of you guys to write?

Thanks, Lozzer

I have a CMSB setup which has a 'report' section, where performance is recorded for an individual person at several times. The report only contains four fields (First Name, Last Name, Date of Birth and ID) relating to the person, with a further dozen fields for each 'performance'. Rather than having to input those four fields each time, I'd like to be able to select an individual from a pulldown list in the Section Editor to populate those four blank fields.

I have been able to get the pulldown list working OK using the following MySQL query:

<?php $numValue = (@$ESCAPED_FILTER_VALUE )? $ESCAPED_FILTER_VALUE : '0'; ?>

SELECT num, CONCAT(FirstName,' ', LastName, ' [', ID,']')
FROM `<?php echo $TABLE_PREFIX ?>report`
WHERE num != <?php echo $numValue; ?>

But I cannot figure out how to make the selection populate then populate those four fields. Any help gratefully received!

Thanks for your reply. I used the generated code for 'user-login.php' which contains the following code:

if (!getPrefixedCookie('lastUrl')) { setPrefixedCookie('lastUrl', @$_SERVER['HTTP_REFERER'] ); } 

I also note that 'websiteMembership.php' page itself has the following code:

if ($returnAfterLogin) { setPrefixedCookie('lastUrl', thisPageUrl()); }

Do these have to be removed? No other pages have the lastUrl cookie...

I have set the following URLs for redirect:

$GLOBALS['WEBSITE_LOGIN_POST_LOGIN_URL'] = '/membersdiary.php';
$GLOBALS['WEBSITE_LOGIN_POST_LOGOFF_URL'] = '/user-logoff.php';

user-logoff is via a text link:  ?action=logoff

On both login and logoff, the page which loads can to be any one a number of previously visited pages (on this website). Logoff certainly never redirects to user-logoff.php

Am I missing something obvious?

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in..............cmsAdmin/lib/login_functions.php on line 308

Anyone seen this message before? Or know of a solution?