title: Select multiple id's php/mysql
body: <p>I need to select multiple id's from my database example:</p>
  
  <pre><code>&lt;input id=1 type="text" name="iDEAL" value=0 size=3&gt;
  &lt;input id=2 type="text" name="PayPal" value=0 size=3&gt;
  </code></pre>
  
  <p>I need to get the id from the database and still have the value from the input so now i have</p>
  
  <pre><code>$ideal = $_POST['iDEAL'];
  $paypal = $_POST['PayPal'];
  </code></pre>
  
  <p>I was thinking i need some mysql query like the following: </p>
  
  <pre><code>$query = "SELECT bet_id FROM betalingsmethode WHERE  bet_id = ". $_POST['id'] . ""
  </code></pre>
  
  <p>From this point on I am stuck I can't think of a way to make this happen 10 times including formulas. I thought of a switch but then realised it stops after the first hit so that won't be an option.</p>
  
  <p>I hope you guys have a solution.</p>
  
  <p>E//</p>
  
  <p>my database has the following structure</p>
  
  <pre><code>Betaalmethodes
   bet_id
   bet_naam
  
  bundels
   bundels_id
   psp_id
   etc
  
  tarieven
   id
   bet_id
   etc
  </code></pre>
  
  <p>I need to know the bet_id so i can tell php which bundle it needs to use for the formula same goes for 'tarieven' where i'll need the correct bundel_id.</p>