Hey everyone

im bad at explaining things so sorry if i dont make any sense...right ive done all the chapters that are to do with the movie site and now im trying to expand on it and make it proper dummy site for my portfolio.

currently ive just split the fullname field into first name and surname which ill need to do for something im planning to do later but now i cant get peoples full names to show up in the list boxes for movie.php again only one field(full or surname) ive got a good idea of what i need to do i just not sure about whats the code u use to do it
one of my attempts was to edit the $people[$row[.... row but no luck any ideas?

  $peoplesql = "SELECT * FROM people";

  $result = mysql_query($peoplesql)
    or die("Invalid query: " . mysql_error());
  while ($row = mysql_fetch_array($result)) {
    $people[$row['people_id']] = $row['people_firstname' . 'people_surname'];
  }