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. Quote Link to comment 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? Quote Link to comment 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? Quote Link to comment 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"); Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.