Favorite Movies : Need help with a tiny scripts

[eluser]Mischievous[/eluser]
I would use a 2 table setup in your database and not run with a commas separated field.

For example:

Users_table: id, name

Movies_table: id, user_id, movie

Then on the input form just grab the movies list... run your

Code:

$moviesArr = explode(",",$_POST['movies']);

Then just do a while or for loop to run through the array and insert each movie into the database corresponding with the user_id.

Code:

for($i = 0; $i <= count($moviesArr)-1; $i++)
{
  $query = "INTO movies (user_id, movie) VALUES ('$user', '$moviesArr[$i]')";
  $queryresult = mysql_query($query);
  if($queryresult){
     echo($moviesArr[$i]."Movie added to database, thanks for your submission");
  }else{
     echo("There was a problem adding ".$moviesArr[$i]." into the database");
  }
}