newbie join queries. have written join query 2 tables viz; candidate , candidate_contact. cand_number primary key in candidate table , fk in candidate_contact. cand_cid primary key in candidate_contact after submitting query data not being displayed. printing till -echo " in result ";
if(isset($_post['candi_s_by_code'])) { $sql="select * candidate,candidate_contact candidate.cand_number=candidate_contact.cand_number , candidate.cand_number=$candname"; echo "selected candidate code"; } $result = mysql_query($sql) or die(mysql_error()); echo "in result"; while($row=mysql_fetch_array($result)) { $firstname =$row['cand_fname']; $lastname=$row['cand_lname']; $mail=$row['cand_mail']; $telephone=$row['cand_tel']; $mobile=$row['cand_mobile']; }
you closing button's click bracket on sql query dont no u r getting $candname way
if(isset($_post['candi_s_by_code'])) { $sql="select * `candidate,candidate_contact` `candidate.cand_number`=`candidate_contact.cand_number` , `candidate.cand_number`='".$candname."'"; $result = mysql_query($sql) or die(mysql_error()); while($row=mysql_fetch_assoc($result)) { $firstname =$row['cand_fname']; $lastname=$row['cand_lname']; $mail=$row['cand_mail']; $telephone=$row['cand_tel']; $mobile=$row['cand_mobile']; }} 