Re: [PHP] Still trying to figure this out...

[Rob W.]

This also didnt work, Still giving me no output just like the last try.
  ----- Original Message ----- 
  From: Xavier Casto 
  To: Rob W. 
  Cc: php-general@lists.php.net 
  Sent: Monday, June 19, 2006 4:33 PM
  Subject: Re: [PHP] Still trying to figure this out...


  Have you ever thought of doing something like this:

  for($i = 0; $i <= $maxport; $i++)
  {
      $query="SELECT switchport FROM network WHERE switchport = ".$i;
      $result=mysql_query($query);
      if(empty($result)) 
      {
          echo "<p>$i</p>";
      }
  }


  It should only return the ones that aren't in the table and they will 
automatically be sorted in ascending order.



  On 6/19/06, Rob W. <[EMAIL PROTECTED]> wrote:
    Ok, I am still trying to get this figured out from what I tried doing last 
night. If anybody wants to try it, please be my guest. This is the deal. Create 
an INTEGER table. Put the numbers 1 - 24 in it. Leave out like number 8, 9, 22, 
23 ect.. Now create a php statement that will take and pull that out of the 
database, find out the missing numbers and display them as an html drop down 
selection. 

    And tedd in response to why, is because the values that are already located 
in the database represent in use already. They represent a server port that a 
server is sitting on, so that's not the problem. I could have done that along 
time ago. 

    Any help is appreciated but here is the current code that I have.


      $query="SELECT switchport FROM network";
      $result=mysql_query($query);
      $sql_range=mysql_fetch_array($result);
      $true_range=range(1,24); 
      $next_range=array_diff($true_range,$sql_range);
      foreach ($next_range as $final_range) {
         echo "<option value='$final_range'>$final_range\n";
      }