title: Query for one value in multiple MSSQL tables sequentially in PHP
body: <p>I have 2 tables i need to query for a single result, but if it's found in $table0, I need to stop searching and use the values in that row.  Something like this:</p>
  
  <pre><code>$p1_sql = "SELECT TOP 1 * FROM '$table0' WHERE phone1 = '$cidnumber'";
  $p2_sql = "SELECT TOP 1 * FROM '$table0' WHERE phone2 = '$cidnumber'";
  $c1_sql = "SELECT TOP 1 * FROM '$table1' WHERE contactphone = '$cidnumber'";
  $c2_sql = "SELECT TOP 1 * FROM '$table1' WHERE contactphone2 = '$cidnumber'";
  $c3_sql = "SELECT TOP 1 * FROM '$table1' WHERE contactphone3 = '$cidnumber'";
  $c4_sql = "SELECT TOP 1 * FROM '$table1' WHERE contactphone4 = '$cidnumber'";
  
  $p1_res = mssql_query($p1_sql);
  $p1_row = mssql_num_rows($p1_res);
  
  $p2_res = mssql_query($p2_sql);
  $p2_row = mssql_num_rows($p2_row);
  
  $c1_res = mssql_query($c1_sql);
  $c1_row = mssql_num_rows($c1_res);
  
  $c2_res = mssql_query($c2_sql);
  $c2_row = mssql_num_rows($c2_res);
  
  $c3_res = mssql_query($c3_sql);
  $c3_row = mssql_num_rows($c3_res);
  
  $c4_res = mssql_query($c4_sql);
  $c4_row = mssql_num_rows($c4_res);
  
  if ($p1_row = 1){
      $p1_res = $newres;
      goto okres;
  } elseif ($p2_row = 1) {
      $p2_res = $newres;
      goto okres;
  } elseif ($c1_row = 1) {
      $c1_res = $newres;
      goto okres;
  } elseif ($c2_row = 1) {
      $c2_res = $newres;
      goto okres;
  } elseif ($c3_row = 1) {
      $c3_res = $newres;
      goto okres;
  } elseif ($c4_row = 1) {
      $c4_res = $newres;
      goto okres;
  } else {
      $newres = "na";
      goto nares;
  }
  
  okres:
  $cid_sel = mssql_query("SELECT TOP 1 * FROM '$table0' WHERE phone1 = '$cidnumber'");
  </code></pre>
  
  <p>This, however, is ugly and doesn't work.  I was trying to use 'for each...' or 'while (something)', but couldn't wrap my head around how it would work.  I don't even know if it would.  What's the best way to go about this?  It's my first forray into something like this and any help is appreciated.</p>