select help

Hey Ray

Have got a drop down in the back end tht the user can select 'location1', 'location2' or both - these are not dynamic - location1 = 1, location2 = 2 and both = 0

On the front end, have got a dynamic page which am trying to show the relevant content appropriate to that page which am trying to get to show the teammembers based on what they have stored in StaffLocation (either 0, 1 or 2)

If 0, then they need to be shown on both pages, if they are only in 1 or the other location to then show them on that page only.

thanks

What happens when you make the change in the admin? Does it get saved in the database? What column should be filtered on the front end from what table? I'm just a little confused about the details of how it should work and that is preventing me from being able to advise you on how to do it.

Yes, it gets stored in the db in the staff table in column StaffLocation (and its saved as either 0,1 or 2)

Then on the front end what table and column are you wanting filtered based on that result. I'm still confused about that part.

ok sorry. the page main content is coming from the PageContents rs and the TeamMember rs needs to show the staff based the 2 locations that are in the about navigation drop down: http://clients.motley.site/step/location/salisbury

SELECT * FROM staff WHERE Live = 1 AND (StaffLocation = ? OR StaffLocation=0) ORDER BY StaffOrder ASC

And then use a parameter to set the StaffLocation to 1 or 2 based on which location you are viewing by passing in a url parameter.

like this?

$TeamMember = new WA_MySQLi_RS("TeamMember",$DBConnection,0);
$TeamMember->setQuery("SELECT * FROM staff WHERE Live = 1 AND (StaffLocation = ? OR StaffLocation=0) ORDER BY StaffOrder ASC");
$TeamMember->bindParam("i", "".(isset($_GET['loc'])?$_GET['loc']:"")  ."", "-1"); //StaffLocation
$TeamMember->execute();

Sure, if you are passing in the StaffLocation value from the url.