title: Getting multiple row ID's without loop
body: <p>The values I have are in a session. I can't use JOIN (I assume) because that is for multiple tables. I'm working with one table. </p>
  
  <p>The table is called 'VEHICLES'. Each row has a field called 'car' and has an AUTO INCREMENTED ID. I need the ID for each $car*. So I would like a query that will pull ID's only if $car* exists. </p>
  
  <p>There will always be at least one $car*. But 2, 3, 4 cars etc... are possible. How can check for, and query these possibly existing $cars?</p>
  
  <pre><code>$car1 = 'Honda';
  $car2 = 'Mazda';
  $car3 = '';
  
  $query="SELECT
    id( WHERE car='$car1') as My_car1,
    id( WHERE car='$car2') as My_car2,
  FROM VEHICLES";
  
  list($My_car1,$My_car2)=pdo_fetch_array(pdo_query($query));
  </code></pre>
  
  <p>I realize my query is wrong and will not work. But it was the only way I could visually explain what I am trying to do. </p>