Repeating

[june_c21]

hi, how come my output is repeating with this code? what's wrong? Please help. thanks

 

$queryAA="SELECT staff_no from report ";

$resultAA = mysql_query($queryAA,$dblink);

while($rowAA = mysql_fetch_row($resultAA))

{

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user,report WHERE report.staff_no = user.staff_no and status ='approve' and user.bank ='Maybank' and report.staff_no = '$rowAA[0]' " ;

// echo $query;

$result = mysql_query($query,$dblink);

while($row = mysql_fetch_row($result))

  {

  // $x_pos = $pdf->SetX(50);

  $y_pos = $pdf->GetY();

  $pdf->SetX(40);

  $pdf->Cell(50,6,$row[0],1,0,'C',1);

  $pdf->SetX(90);

  $pdf->Cell(40,6,$row[1],1,0,'C',0);

  $pdf->SetX(130);

  $pdf->Cell(80,6,$row[2],1,0,'C',0);

  $pdf->SetX(210);

  $pdf->Cell(20,6,$row[3],1,1,'C',0);

 

}

[MadTechie]

its probably the SQL statement..

try

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount LEFT JOIN report on report.staff_no= user.staff_no FROM user WHERE status ='approve'

 

 

[june_c21]

MadTechie ,error with your query...

[MadTechie]

what was the error ?

[june_c21]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Web\claim\maybank_report.php on line 62

[MadTechie]

I spotted it (i think)

try

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'

[june_c21]

Parse error: syntax error, unexpected T_STRING in C:\Web\claim\maybank_report.php on line 59

[MadTechie]

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'";

 

add the "; to the end

[june_c21]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Web\claim\maybank_report.php on line 62

[june_c21]

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'and user.bank='maybank'and user.staff_no= '$rowAA[0]'" ;

 

the result will repeat 3 times for each row of record

[MadTechie]

run this and tell me how many rows you have and the also post the A's and B's echo'd

 

its kinda hard you workout the problem without knowing the database

 

$queryAA="SELECT staff_no from report ";
$resultAA = mysql_query($queryAA,$dblink);
while($rowAA = mysql_fetch_row($resultAA))
{
echo "A";
$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'and user.bank='maybank'and user.staff_no= '$rowAA[0]'" ;
// echo $query;
$result = mysql_query($query,$dblink);
while($row = mysql_fetch_row($result))
  {
echo "B";
  // $x_pos = $pdf->SetX(50);
  $y_pos = $pdf->GetY();
  $pdf->SetX(40);
  $pdf->Cell(50,6,$row[0],1,0,'C',1);
  $pdf->SetX(90);
  $pdf->Cell(40,6,$row[1],1,0,'C',0);
  $pdf->SetX(130);
  $pdf->Cell(80,6,$row[2],1,0,'C',0);
  $pdf->SetX(210);
  $pdf->Cell(20,6,$row[3],1,1,'C',0);

}[code]

[/code]

[june_c21]

ABBBBBBBBABBBBBBBBABBBBBBBBABBBBBBBBABBBBBBBBABBBBBBBBABBBBBBBBABBBBBBBBAAAAABBABBABBABBABAAAAAAAAAAAA

 

 

 

sorry to trouble you, hope you can help as i need to complete my assignment today. thanks

[MadTechie]

do you have a database sceama and some sample data..?

 

other than that i would have to guess

 

$query="SELECT DISTINCT  user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'and user.bank='maybank'and user.staff_no= '$rowAA[0]'" ;

[june_c21]

Account Number                      Staff No                        Name                      Amount                    Total

1234567890                                A                                Ali                            20 

1234567890                                A                                Ali                            10

1234567890                                A                                Ali                            15                            45

 

1234567890                                A                                Ali                            20 

1234567890                                A                                Ali                            10

1234567890                                A                                Ali                            15                            45

 

1234567890                                A                                Ali                            20 

1234567890                                A                                Ali                            10

1234567890                                A                                Ali                            15                            45

 

 

this is the repeat result.

[MadTechie]

looks like the first loop isn't needed

 

$query="SELECT user.acc_no, report.staff_no, user.name, report.amount FROM user LEFT JOIN report on report.staff_no= user.staff_no WHERE status ='approve'and user.bank='maybank' " ;
// echo $query;
$result = mysql_query($query,$dblink);
while($row = mysql_fetch_row($result))
  {
  // $x_pos = $pdf->SetX(50);
  $y_pos = $pdf->GetY();
  $pdf->SetX(40);
  $pdf->Cell(50,6,$row[0],1,0,'C',1);
  $pdf->SetX(90);
  $pdf->Cell(40,6,$row[1],1,0,'C',0);
  $pdf->SetX(130);
  $pdf->Cell(80,6,$row[2],1,0,'C',0);
  $pdf->SetX(210);
  $pdf->Cell(20,6,$row[3],1,1,'C',0);

}

 

NOTE: your need to remove the next } below the last one in the posted code

[june_c21]

i must user the first loop else the total won't be display.

[MadTechie]

how is the first loop linked to the total ?

[june_c21]

this is the complete code ....

 

$queryAA="SELECT staff_no from report ";

$resultAA = mysql_query($queryAA,$dblink);

while($rowAA = mysql_fetch_row($resultAA))

{

$query="SELECT report.staff_no, user.name, report.details,report.amount FROM user,report WHERE report.staff_no = user.staff_no and status ='approve' and user.bank ='Maybank' and report.staff_no = '$rowAA[0]' " ;

// echo $query;

$result = mysql_query($query,$dblink);

while($row = mysql_fetch_array($result))

  {

  // $x_pos = $pdf->SetX(50);

  $y_pos = $pdf->GetY();

  $pdf->SetX(40);

  $pdf->Cell(50,6,$row[0],1,0,'C',1);

  $pdf->SetX(90);

  $pdf->Cell(40,6,$row[1],1,0,'C',0);

  $pdf->SetX(130);

  $pdf->Cell(80,6,$row[2],1,0,'C',0);

  $pdf->SetX(210);

  $pdf->Cell(20,6,$row[3],1,1,'C',0);

}

 

  $query1 = "SELECT SUM(amount) FROM report where staff_no = '$rowAA[0]'and report.status='approve'";

  $result1 = mysql_query($query1, $dblink);

  $myrow1 = mysql_fetch_row($result1);

{

  $pdf->SetX(230);

  $pdf->Cell(20,6,$myrow1[0],1,'C',0);

  $pdf->Ln();

}

}

 

[MadTechie]

$queryAA="SELECT staff_no from report ";

should be

$queryAA="SELECT DISTINCT staff_no from report ";

[june_c21]

ya, i just edit it but it didn't appear all the record in the database. why?