sridhar golyandla Posted March 17, 2009 Share Posted March 17, 2009 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. Link to comment https://forums.phpfreaks.com/topic/149787-arrays/ Share on other sites More sharing options...
btherl Posted March 17, 2009 Share Posted March 17, 2009 Do you want a list of all candidates along with all papers they have applied for? Link to comment https://forums.phpfreaks.com/topic/149787-arrays/#findComment-786535 Share on other sites More sharing options...
sridhar golyandla Posted March 17, 2009 Author Share Posted March 17, 2009 Yes, and i have to check out whether that candidate is applied for the particular paper or not? Link to comment https://forums.phpfreaks.com/topic/149787-arrays/#findComment-786545 Share on other sites More sharing options...
suma237 Posted March 17, 2009 Share Posted March 17, 2009 $qry=mysql_query("select * from paper where applyid=$candaidateid"); Link to comment https://forums.phpfreaks.com/topic/149787-arrays/#findComment-786550 Share on other sites More sharing options...
sridhar golyandla Posted March 17, 2009 Author Share Posted March 17, 2009 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. Link to comment https://forums.phpfreaks.com/topic/149787-arrays/#findComment-786570 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.