title: PHP/MYSQL: SELECT statement, multiple WHERE's, populated from database
body: <p>I'm trying to figure out how to get a select statement to be populated by an ever-changing number of where's. This is for an order-status tracking application.</p>
  
  <p>Basically, the idea is a user (customer of our company) logs in, and can see his/her orders, check status, etc. No problem. The problem arises when that user needs to be associated with multiple companies. Say they work or own two different companies, or they work for a company that owns multiple sub-companies, each ordering individually, but the big-shot needs to see everything ordered by all of the companies. This is where I'm running into a problem. I can't seem to figure out a good way of making this happen. The only thing I have come up with is this: <br /></p>
  
  <pre><code>
  client='Client Name One' OR client='Client name two' AND hidden='0' OR client='Client name three' AND hidden='0' OR client='Client name four' AND hidden='0'
  </code></pre>
  
  <p>(note that client in the previous code refers to the user's company, thus our client)<br /></p>
  
  <p>placed inside of a column called company in my users table of the database. This then gets called like this:<br /></p>
  
  <pre><code>
  $clientnamequery = "SELECT company FROM mtc_users WHERE username='testing'";
  $clientnameresult = mysql_query($clientnamequery);  list($clientname)=mysql_fetch_row($clientnameresult);
  
  $query  = "SELECT -redacted lots of column names- FROM info WHERE hidden='0' AND $clientname ORDER BY $col $dir";
  $result = mysql_query($query);
  </code></pre>
  
  <p>Thing is, while this works I can't seem to make PHP add in the client=' and ' AND hidden='0' correctly. Plus, it's kind of kludgy.</p>
  
  <p>Any ideas? Thanks in advance!</p>