Search the Community
Showing results for tags 'php loop last coma'.
Found 1 result
-
Hi guys, I have a very basic issue, Im trying to get these results (List all result with coma and delete last coma) like : actor 1, actor 2 My total entries are two in mysql but i get first result duplicated and no coma! This is my code, could you please help me spotting my mistake? Thank you all $select_actors=mysql_query("SELECT * FROM actors_in_movies WHERE movie_ref='$movie_ref'"); if (mysql_num_rows($select_actors)>=1) { while ($row=mysql_fetch_array($select_actors)) { $actor_ref=$row['actor_ref']; $select_actor_name=mysql_query("SELECT * FROM actors WHERE actors_ref='$actor_ref' AND active='1'"); while ($row_actor=mysql_fetch_array($select_actor_name)) { $actor_name.=$row_actor['actors_name'].","; $actor_name = substr(trim($actor_name), 0, -1); echo" $actor_name"; }}}
