I want to select record from three tables that has a unique field(acc_no). Mysql query i used successfully selected the records but duplicates the result when outputing it. I'm using php script. Plz can someone help me with a code to eliminate this duplicative behaviour. Thanks.
The code i used was :
<?php
$val=$_POST['textfield'];
$myquery=mysql_select_query("SELECT* FROM deposit, withdrawal, charges WHERE deposit.acc_no=withdrawal.acc _no AND withdrawal.acc_no=charges.acc_no AND deposit.acc_no='$val' " ) ;
while($r2=mysql_fetch_array($myquery)){
$a1=$r2['depositor']; echo $a1;
$a2=$r2['depositAmt']; echo $a2;
$a3=$r2['withdrawee']; echo $a3;
$a4=$r2['withdrawalAmt']; echo $a4;
$a5=$r2['chargeDescription']; echo $a5;
$a6=$r2['chargeAmt']; echo $a6;
}
?>