Starfox Posted May 2, 2007 Share Posted May 2, 2007 Greetings folks. Currently I'm the owner of a website that is dedicated to an online gaming community. The site is html, and it relies a lot on me to update things. I would like to give access to people without having them know html or give them ftp access. So I'm creating an Admin Control Panel php page, and converting several of the site webpages to php. The Admin CP is just one giant Form, and outputs from this form go on the various pages. k, let me get to the point. I'd love to get some help on the actual logic to do this, but also some specific syntax questions. For example, the mysql select, is in this form: SELECT column FROM table WHERE column operator value My question is, can you have several "wheres" so like SELECT column FROM table WHERE column operator value AND WHERE column operator value So say you have a list of users, and each has a different access level and is assigned to a different unit within the organization. When generating a list of usernames that they have access to edit, I would like to select names under their juristiction. So like slecect username FROM table WHERE Unit = unitname AND WHERE Access <= 4 Would this be possible? Thanx in advance, I'll start with this simple question. See how it goes from there. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.