[SOLVED] so I have an array that goes like like this 2,42,78,2 how can can I...

[jonaofarc]

so I have an array that goes like like this 2,42,78,2 how can can I break it apart so that I can do a mysql entry intro each of those rows, what i mean is

 

mysql_query("INSERT INTO message WHERE user_id=2")"

mysql_query("INSERT INTO message WHERE user_id=42")"

mysql_query("INSERT INTO message WHERE user_id=78")"

mysql_query("INSERT INTO message WHERE user_id=2")"

[redarrow]

what u mean?

 

 

[trq]

$array = array(2,42,78,2);

foreach ($array as $k) {
  mysql_query("INSERT INTO message WHERE user_id=$k");
}

[jonaofarc]

thanks so much