selecting multiple rows from a table with where

mysqli and php5

[John_Keates]

Hi, I can't find out how to select multiple rows
(SQL: SELECT pid FROM photo_photos WHERE aid='1')
there are multiple rows with aid 1 so how do I get everything in an array?

[omoutop]

hi John_Keates!

This is simple, you need a while loop in order to fetch all of them, for instance:

$select = "SELECT pid FROM photo_photos WHERE aid='1'";
$run = mysql_query($select) or die (mysql_error());
while ($row = mysql_fetch_assoc($run))
{ //loop starts
$pid = $row['pid'];
echo $pid;
} //loop ends

instead of :
$pid = $row['pid'];
echo $pid;

you can always use :

echo $row['pid'];

Try it out

[John_Keates]

Thanks, now I understand how to use that query with a while.