[SOLVED] Query inside while loop?

[waynew]

Hey guys.

 

I'm taking a list of distinct contact names from a table and placing them into an array. That's working well; did a var dump and everything is fine. My problem is in using that contact names array to select other values from another table. I've tried everything and keep getting a 500 error off Apache. Here's the code. Any help would be great.

 

while($i < sizeof($contacts){
  
  $contact_person = $contacts[$i];
  $result = mysql_query("Select phone from jobs where contact_name = '$contact_person' limit 1");
  $i++;

 

PS: I know that there is a problem with me using result repeatedly, which would result in the result being overwritten each time. Is there any solution to this problem? ??? ???

[CrazeD]

To prevent $result from being overwritten, you can turn it into an array by doing $result[] = mysql_query("Select phone from jobs where contact_name = '$contact_person' limit 1");

 

Not sure if that helps you.

[waynew]

Changed to:

 

<?php 
  
  $i = 0;
  while($i < sizeof($contacts){
  
  $contact_person = $contacts[$i];
  $result[$i] = mysql_query("Select phone from jobs where contact_name = '$contact_person' limit 1");
  $i++;
  
  }
   ?> 

 

Still getting a 500 error.

[waynew]

OH GOD DAMN IT:

 

I was missing a bracket!