You need to edit the authenticate user behavior and set it to not go anywhere on login success.
add the redirect to the index.php page to the update record behavior.
Thanks Jason for the reply.
I did get rid of the redirect to index.php as advised and this served to update the LoginCount Column and LoginDate column respectively. The only problem is that the LoginCount value is static and no matter how many times I log in, logout and repeated all over again, the LoginCount yields a static value of 1 and does not reflect the number of times a user logs in.
In essence, this code <?php echo $row_rsLoggeduser['LoginCount']+1; ?> outputs the static value of 1 in the LoginCount Column. If it is changed to say 10 i.e., <?php echo $row_rsLoggeduser['LoginCount']+10; ?>, an output value of 10 is registered in the LoginCount Column of the user table no matter how many times a person logs in.
I was wondering if the LoginCount column needs to be defined or set so that it automatically increments by a value of 1 every time registered users log in. If that is indeed the case, how do I go about it and more precisely can you please let me know the code needed to achieve this.
Thank you for your help.