query problem.

[Scip]

I have an array of key value pairs and i am trying to use a foreach loop  to loop through the array performing a database query for each key  and as such i only expected one value to be return but it returns the whole column.

 

here is the code i am using:

 

  foreach($requests as $key => $value){


	$query = "SELECT quantity FROM resource WHERE resource_name = '{$key}' ";
	$result_set = mysql_query($query,$connection);
	confirm_query($result_set);
}

 

a print_r after the result_set has been fectched to a variable  shows the results for quantity for every row in the table 'resource' whilst it should only for the row with the resource_name of $key;

 

any help it appreciated, thanks in advance.

[Scip]

managed to solve it but created another problem.  :-X

[JJ2K]

Well whats the new problem and how did you solve it