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?

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.

thanx guys.... I need to check whether the candidate has applied for a particular paper or not. if the candidate has applied for that paper, it shows the alert msg and it should not update the paper table with that particular candidate id.

Yes, and i have to check out whether that candidate is applied for the particular paper or not?

Thanks in advance... Please help me out from the array problem... Having two tables, candidate and paper... Iam storing the candidate id with the particular paper id, like these apply_id is the candidate id, stored in the paper table, $qry=mysql_query("select * from paper"); $num=mysql_num_rows($qry); $row=mysql_fetch_array($qry); echo '<br />'; $applyid=$row['apply_id']; $new_aply=$applyid.','.$registerid; I need to check whether the candidate has applied for a particular paper or not. if the candidate has applied for that paper, it shows the alert msg.

shall v put hyperlink to each name? and it moves one by one?

It's working well... Thanks to neil.johnson

plz, need help urgently Am new bie to php and mysql... My question is : How to display all the names from database table in a marquee function, which directs from down-to-up. $query=mysql_query("select * from employee where status='Active'"); $num=mysql_num_rows($query); while($row=mysql_fetch_object($query)) { $list .= $row->names; echo substr($list, 0); } by using these query, it displays only last record of the table. plz help me out, how to display all the names from the db.

hi 2 all, i am new to php and mysql... please any body can help me out, egarly waiting for the solution... how to active and deactivate the 2nd and 3rd dropdown boxes for selecting a particular first dropdown value. the 2nd and 3rd dropdowns are related to 1st dropdown and the values are posted from backend ie DB.