Spliting Problem

[sridhar golyandla]

Hi 2 all,

 

    Am new bie to php and mysql. am getting problem with spliting the values which coming from the mysql.

$qry=mysql_query("select * from table_name where id=$id");

$num=mysql_num_rows($qry);

$row=mysql_fetch_array($qry);

$applyid=$row['apply_id'];

  $new_aply=$applyid.','.$rid;

$insql=mysql_query("INSERT INTO table_name (fields) values ('$new_aply')");

 

Now the values are inserted successfully with "COMMAS". like

$new_aply = 1,2,3.......

 

Now when fetching the values it comes values along with the the commas.

Now i have to check it out each value seperatley and print the the values of the corresponding 'id'.

 

Please help me out.

[sridhar golyandla]

by using explode, i can split the values, like these

 

$rid=explode(',',$registerid);

 

print_r($rid);

1 2 3 ......

 

but how should i check the each values in to the select statement to get the corresponding values of that particular rid?

[sasa]

look http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set

[sridhar golyandla]

How can i get each value separatley and how should i fetech the values of corresponding id's.