List Options Advanced Query
3 posts by 2 authors in: Forums > CMS Builder
Last Post: April 12, 2012 (RSS)
By concrete - April 11, 2012
I created a checkbox in the cms_accounts table.
I need to detect if it is true or not to display the correct list options for the user.
Here is an example of what im tyring to do.
if ({custom_checkbox}) {
select num, title from cms_table where field = {cms_accounts.num}
} else {
select num, title from cms_table
}
1. What variable should i can to get the value of the checkbox?
2. What variable should i call to get the user id of the currently logged in user?
I need to detect if it is true or not to display the correct list options for the user.
Here is an example of what im tyring to do.
if ({custom_checkbox}) {
select num, title from cms_table where field = {cms_accounts.num}
} else {
select num, title from cms_table
}
1. What variable should i can to get the value of the checkbox?
2. What variable should i call to get the user id of the currently logged in user?
Re: [concrete] List Options Advanced Query
By Jason - April 11, 2012
Hi,
For both of these, you can use the $CURRENT_USER variable.
I'm assuming you need to do this for the query of a list field?
If, for example, your check box was called "display", you could do something like this:
Hope this helps
For both of these, you can use the $CURRENT_USER variable.
I'm assuming you need to do this for the query of a list field?
If, for example, your check box was called "display", you could do something like this:
<?php if ($CURRENT_USER['display']): ?>
select num, title from cms_table where field = '<?php echo $CURRENT_USER['num'];?>
<?php else: ?>
select num, title from cms_table
<?php endif ?>Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/