Select Query

[Nickosssss]

Hello there i have an array with some stored values that need to be verified on the database

how can i insert that array to a select statement? I am using this but doesnt work with the fetch_assoc conficts with the $unallocatedStuds array i am using as a filter

anybody knows?

thank u

for ($j = 0; $j < $count1; $j++)
{
$query2 = "SELECT c.top_stud_id, c.stud_id, c.top_id, c.dt, c.top_pref, (1000 + (4 - s.level) 10 + (30 - c.top_pref 5))
as weight from top_stud c left join student s on
c.stud_id = s.stud_id and s.stud_id = $unallocatedStuds[$j] order by weight asc, dt desc";

}
$res2 = $db->query($query2);

$studTop2 = array();

while ($row_studTop2 = mysqli_fetch_assoc($res2))
{

$studTop2[$row_studTop2['stud_id']] = $row_studTop2['top_id'];

}
print_r($studTop2);
}

[Roger_Ramjet]

Simplest way is to let SQL do the work.

If you inplode the array into a comma-seperated string, then you use that string as a value list in an SQL query.

$stud_string = implode("," , $unallocatedStuds);
$query1 = "SELECT  c.top_stud_id, c.stud_id, c.top_id, c.dt, c.top_pref, (1000 + (4 - s.level) * 10 + (30 - c.top_pref * 5)) AS weight 
FROM top_stud c LEFT JOIN student s ON c.stud_id = s.stud_id 
WHERE s.stud_id IN (" . $stud_string . ")
ORDER BY weight asc, dt desc";

Not sure that I follow the logic here though?? My guess is that all students in top_stud will always be in student - so why the Left Join?

Anyway, the idea here is to get all the results with 1 query instead of running multiple queries.