[eluser]Ram_Kalva[/eluser]
Hi in this query i am not able to excute the second query so can any once please tell me where is this problem in this query or else in the code please help me please see this code in this iam extrating 2 different tables but i need all data need to extract from this...
else if($type == 'mrafiscal')
{
$split = split("-",$sort_date);
$newdate = $split[0]."-".$split[1]."-01";
// echo "SELECT nbc.fiscal_date,nbc.nbc_deposit_date,rlm.member_surname,rlm.member_name,nbc.nbc_idno,nbc.nbc_mra_policyno,nbc.mem_contribution,nbc.emp_contribution,nbc.nbc_total_amount,nbc.nbc_FC,nbc.nbc_GL,nbc.nbc_RI FROM nbc_upload nbc LEFT JOIN rlm_member rlm,tt_member_transactions tt_mem ON (nbc.member_seq=rlm.member_seq AND nbc.member_seq=tt_mem.member_seq ) WHERE nbc.fiscal_date='".$sort_date."' ORDER BY fiscal_date <br>";
$member_sql=mysql_query("SELECT tt_mem.fc,
tt_mem.gl,
tt_mem.ri,
nbc.fiscal_date,
nbc.nbc_deposit_date,
rlm.member_surname,
rlm.member_name,
nbc.nbc_idno,
nbc.nbc_mra_policyno,
nbc.mem_contribution,
nbc.emp_contribution,
nbc.nbc_total_amount,
nbc.nbc_FC,
nbc.nbc_GL,
nbc.nbc_RI
FROM nbc_upload nbc LEFT JOIN rlm_member rlm ON (nbc.member_seq=rlm.member_seq )
LEFT join tt_member_transactions tt_mem ON (nbc.member_seq = tt_mem.member_seq)
WHERE nbc.nbc_deposit_date='".$sort_date."' ORDER BY fiscal_date ") or die(mysql_error());
//echo "FIRST QUERY: ".mysql_num_rows($member_sql)."<br>";
while($mem=mysql_fetch_array($member_sql))
{
$i = 1;
$transactions[] = array('member_number'=> $mem['nbc_mra_policyno'],
'first_name'=> $mem['member_name'],
'last_name'=> $mem['member_surname'],
'idno'=> $mem['nbc_idno'],
'fiscal_date'=>$mem[fiscal_date],
'nbc_deposit_date'=>$mem[nbc_deposit_date],
'member_seq' => $row[member_seq],
'member_contribution' =>$mem[mem_contribution],
'emp_contribution'=>$mem[emp_contribution],
'nbc_total_amount'=>$mem[nbc_total_amount],
'nbc_FC'=>$mem[nbc_FC],
'nbc_GL'=>$mem[nbc_GL],
'nbc_RI'=>$mem[nbc_RI],
'fc' => $mem['fc'],
'gl' => $mem['gl'],
'ri' => $mem['ri'],
'type'=>'fiscal');
}
// echo "SECOND QUERY: ".mysql_num_rows($member_sql1)."<br>";
$member_sql1=mysql_query("SELECT (rlm.member_seq),tt_mem.transaction_date, rlm.member_surname, rlm.member_name,tt_mem.fc, tt_mem.gl,tt_mem.ri, rlm.member_id_number
FROM tt_member_transactions tt_mem, nbc_upload nbc, rlm_member rlm
WHERE nbc.member_seq!= tt_mem.member_seq AND rlm.member_seq!= nbc.member_seq
AND tt_mem.member_seq = rlm.member_seq AND (transaction_date = '".$sort_date."' AND nbc.nbc_deposit_date ='".$sort_date." GROUP BY rlm.member_seq') LIMIT 500") or die(mysql_error());
while($mem=mysql_fetch_array($member_sql1))
{
$i = 1;
$transactions[] = array( $mem['nbc_mra_policyno'],
'first_name'=> $mem['member_name'],
'last_name'=> $mem['member_surname'],
'idno'=> $mem['member_id_number'],
'fiscal_date'=>$mem['fiscal_date'],
'nbc_deposit_date'=>$mem["transaction_date"],
'member_seq' => " ",
'member_contribution' =>" ",
'emp_contribution'=>" ",
'nbc_total_amount'=>" ",
'nbc_FC'=>" ",
'nbc_GL'=>" ",
'nbc_RI'=>" ",
'fc' => $mem['fc'],
'gl' => $mem['gl'],
'ri' => $mem['ri'],
'type'=>'fiscal');
}
}
