Membership: List CURRENT USER items only
25 posts by 6 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: August 4, 2011 (RSS)
By s2smedia - March 24, 2010
heres my scenerio...
When a project is created, I have a drop down of Employees to assign it to.. the drop down pulls in a field "id" which is a field I added to the Accounts section.
so I just need to adjust this code accordingly:
(I added the code you suggested to the other person in this thread, I also have another where clause i need to keep in there "project_status = 'Active'")
<?php
require_once "admin/lib/viewer_functions.php";
list($projectsRecords, $projectsMetaData) = getRecords(array(
'tableName' => 'projects',
'where' => " project_status = 'Active' " "mysql_escapef(" project_manager LIKE ? ", "%\t".$CURRENT_USER['id']."\t%" )",
));
?>
Re: [s2smedia] Membership: List CURRENT USER items only
By Jason - March 24, 2010
I think all you'll need to do put those two statements together with an AND statement:
'where' => " project_status = 'Active' AND mysql_escapef(" project_manager LIKE ? ", "%\t".$CURRENT_USER['id']."\t%" )", [/#000000]
Give that a try.[/#000000]
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Membership: List CURRENT USER items only
By s2smedia - March 24, 2010
Parse error: syntax error, unexpected T_STRING, expecting ')' in /hermes/bosweb/web255/b2559/ipw.s2smedia/frontdesk/index.php on line 18
Re: [s2smedia] Membership: List CURRENT USER items only
By Jason - March 25, 2010
list($projectsRecords, $projectsMetaData) = getRecords(array(
'tableName' => 'projects',
'where' => 'project_status=\'Active\' AND'. mysql_escapef(" project_manager LIKE ? ", "%\t".$CURRENT_USER['id']."\t%" ) ,
));Let me know if that works.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Membership: List CURRENT USER items only
By s2smedia - March 25, 2010
But now the areas where the content should display, is blank.
not sure if maybe I need to flip the code or something..
so basically when I create a "Project"
I select from a drop down (project_manager) which pulls in values "id" from "accounts"
it seems like the code should work... not sure what maybe happening...
Re: [s2smedia] Membership: List CURRENT USER items only
By Jason - March 25, 2010
I need some clarification on the problem.
So, you want to populate a drop down with a list of employees, and this list of employees are stored in the "accounts" table?
If you could post your .php file, I could take a look at it for you.
Thanks,
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Membership: List CURRENT USER items only
By s2smedia - March 25, 2010
I attached a PDF that will explain... its fairly simple what I need.
Re: [s2smedia] Membership: List CURRENT USER items only
By Jason - March 25, 2010
Okay, we're going to try a couple of things. First, we're going to change our "where" statement to the following:
'where' => 'project_manager= "'. $CURRENT_USER['id'] .'"' ,See if that gives you the records you're looking for. If not add this line right underneath the "where" statement:
'debugSql' => true,This will display the SQL query. Send me that information along with the php file you are using and I'll take a look.
Let's give that a try. Let me know what happens.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Membership: List CURRENT USER items only
By s2smedia - March 25, 2010
now I just need i the where=> project_status "active"
Re: [s2smedia] Membership: List CURRENT USER items only
By Dave - March 26, 2010
You can add that back with this:
'where' => 'project_status="Active" AND project_manager= "'. $CURRENT_USER['id'] .'"' ,
If that works, great! If not, and it makes all your results disappear it probably means "Active" isn't the actual value you're wanting to match (or that you don't have any active records).
If that's the case you can remove it again and examine the records being returned by temporarily adding this line:
<?php showme($projectsRecords); ?>
Hope that helps!
interactivetools.com