Mine

 $query_photo = "SELECT * FROM `photographs` WHERE `clientid` = '$clientid' AND `eventid` = '$eventid'  " ;

               $result_photo = mysql_query($query_photo) or die(mysql_error());

               $count = 0;
               // rows

               echo mysql_num_rows($result_photo);


               $photo = array();
               $photo_id = array();
               while($row_photo = mysql_fetch_array($result_photo)){

                array_push($photo, $row_photo['imgname']);
                array_push($photo_id, $row_photo['id']);

              }


$photo[3];