Looping through arrays

[Mr Chris]

Hello All,

 

I have two arrays.  One called $number_array and one called $title_array.

 

  $number_array  = (1,2,3,4);
  $title_array  = ("Title One", "Title Two", "Title Three", "Title Four");

 

Now what I want to do is run through each of the arrays one by one each time I query my database, so for example the first time it would output the query and title as:

 

//First time
SELECT * FROM tbl WHERE something = 1
<optgroup label="Title One">


//Second time
SELECT * FROM tbl WHERE something = 2
<optgroup label="Title Two">

 

//etc..

 

so here's my code:

 

<?
  echo '<select id="class" class="selectbox" name="class">';
  $number_array  = (1,2,3,4);
  $title_array  = ("Title One", "Title Two", "Title Three", "Title Four");
  
   $result = mysql_query ('SELECT * FROM tbl WHERE something = ".$number_array."') or die ('Error: '.mysql_error ());
     echo '<optgroup label="".$title_array."">';
       while ($row = mysql_fetch_array($result)) { 
         echo '<option value="'.$row['id'].'" class="'.$row['name'].'">'.strtoupper($row['name']).'</option>'; 
       } 
          echo '</optgroup>';			
  echo '
</select>';

?>

 

Anyone please help?

[Mr Chris]

Worked it out using foreach and keys.