retrieving multiple values with one mysql query

[fishnfrogs]

Hello everyone! I have an app that uses a for loop to go through an array and it selects all the values from my MySQL database and returns the values. I can't imagine that this is the best approach. My code kinda looks like this:

$array = array('blah', 'bleep', 'bloop');
$password = 'same_value_for_each_item_in_the_array';
$name = 'same_value_for_each_item_in_the_array';
 
$userArray = array();
$passArray = array();
$nameArray = array();
 
for($i=0; $i<count($array); $i++)
    {
    $result = mysql_query("SELECT * FROM `table` WHERE `user`='$array[$i]' AND `password`='$password ' AND `name`='$name ' ORDER BY `date` DESC LIMIT 60");
        if($result) {
            while ($row = mysql_fetch_object($result)) {
            $userArray[] = $row->user;
            $nameArray[] = $row->name;
            $passArray[] = $row->password;
            }
        }
    }
 

Cna anyone offer up a better, more efficient way of going about this? Thanks in advanced!!

[Dormilich]

multiple requests can be more efficiently made using Prepared Statements.

[fishnfrogs]

Hi, thanks for the reply. I actually ended up using a single query string and using a loop to concatenate to it. It all seems to be working quite well. It look my load time from about 15 seconds to about 2. YAY!