Hi... Good day! I just want to know how can I change the format of my table. here is my code: <?php include 'config.php'; $sql = "SELECT DATE_FORMAT(d.FROM_DATE, '%M %c') AS FROM_DATE, DATE_FORMAT(d.TO_DATE, '%M %c, %Y') AS TO_DATE, g.EMP_NO, g.fullName, g.Rate, g.Reg_Hours, g.Basic_Pay, g.OTReg_Hours, g.SunReg_Hours, g.OTSun_Hours, g.HolReg_Hours, g.HolRegOT_Hours, g.HolLeave_Hours_Tot, SUM(g.NPReg_Hours + g.NPSun_Hours + g.NPHol_Hours) AS NIGHT_PREMIUM, SUM(g.MealReg_Hours + g.MealSun_Hours) AS MEAL_ALLOWANCE, g.Cola_Hours, g.Basic_Pay, g.OTReg_Amt, g.SunReg_Amt, g.OTSun_Amt, g.HolReg_Amt, g.HolRegOT_Amt, g.HolLeave_Amt, g.NP_Amt, g.Meal_Amt, g.Cola_Amt, p.COMPANY_NAME, p.PERIOD, p.NAME, p.FIRST_LINE, p.RATE_Label, p.EARNINGS, p.HRS, p.AMOUNT, p.BASIC_PAY_Label, p.REGULAR_OVERTIME, p.SUN_SPEC_HOLIDAY, p.SUN_SPEC_HOL_OT, p.REG_HOLIDAY, p.REG_HOLIDAY_OT, p.HOLIDAY_LEAVE, p.NIGHT_PREMIUM_Label, p.MEAL_ALLOWANCE_Label, p.COLA, p.13TH_MONTH, p.SECOND_LINE FROM $PAYROLL.casual_payslip_label p, $PAYROLL.casual_generate_payroll g, $PAYROLL.casual_date_upload d GROUP BY g.EMP_NO"or die(mysql_error()); $rs_label = $conn2->GetAll($sql); $smarty->assign('rs_label', $rs_label); $smarty->display('payslip.tpl'); $smarty->display('casual_payslip.tpl'); ?> <div> {section name=att loop=$rs_label} <table class="stat"> <tr> <td>{$rs_label[att].COMPANY_NAME}</td> <tr/> <tr> <td>{$rs_label[att].PERIOD} {$rs_label[att].FROM_DATE}-{$rs_label[att].TO_DATE}</td> <tr/> <tr> <td>{$rs_label[att].NAME} {$rs_label[att].fullName}</td> </tr> <tr> <td>{$rs_label[att].FIRST_LINE}</td> </tr> <tr> <td>{$rs_label[att].RATE_Label} {$rs_label[att].Rate}</td> </tr> <tr> <td>{$rs_label[att].EARNINGS} {$rs_label[att].HRS} {$rs_label[att].AMOUNT}</td> </tr> <tr> <td>{$rs_label[att].BASIC_PAY_Label} {$rs_label[att].Reg_Hours} {$rs_label[att].Basic_Pay}</td> </tr> <tr> <td>{$rs_label[att].REGULAR_OVERTIME} {$rs_label[att].OTReg_Hours} {$rs_label[att].OTReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].SUN_SPEC_HOLIDAY} {$rs_label[att].SunReg_Hours} {$rs_label[att].SunReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].SUN_SPEC_HOL_OT} {$rs_label[att].OTSun_Hours} {$rs_label[att].OTSun_Amt}</td> </tr> <tr> <td>{$rs_label[att].REG_HOLIDAY} {$rs_label[att].HolReg_Hours} {$rs_label[att].HolReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].REG_HOLIDAY_OT} {$rs_label[att].HolRegOT_Hours} {$rs_label[att].HolRegOT_Amt}</td> </tr> <tr> <td>{$rs_label[att].HOLIDAY_LEAVE} {$rs_label[att].HolLeave_Hours_Tot} {$rs_label[att].HolLeave_Amt}</td> </tr> <tr> <td>{$rs_label[att].NIGHT_PREMIUM_Label} {$rs_label[att].NIGHT_PREMIUM} {$rs_label[att].NP_Amt}</td> </tr> <tr> <td>{$rs_label[att].MEAL_ALLOWANCE_Label} {$rs_label[att].MEAL_ALLOWANCE} {$rs_label[att].Meal_Amt}</td> </tr> <tr> <td>{$rs_label[att].COLA}{$rs_label[att].Cola_Hours} {$rs_label[att].Cola_Amt}</td> </tr> <tr> <td>{$rs_label[att].SECOND_LINE}</td> </tr> </table> {/section} </div> Code (markup): the output of this code: Company Name Period : jul 09- July 22,2011 Name : Juan Dela Cruz Rate : 339.80 EARNINGS HRS AMOUNT Basic Pay 91.45 3,884.34 Regular Overtime 0.00 0.00 Sun/Spec Holiday 0.00 0.00 Sun/Spec Hol. OT 0.00 0.00 Reg. Holiday 0.00 0.00 Reg. Holiday OT 0.00 0.00 Holiday/Leave 0.00 0.00 Night Premium 0.00 0.00 Meal Allowance 0.00 0.00 COLA (P28 Allow) 0.00 0.00 13th Month 0.00 Company Name Period : jul 09- July 22,2011 Name : Ann Chin Rate : 339.80 EARNINGS HRS AMOUNT Basic Pay 100.00 4247.5 Regular Overtime 0.00 0.00 Sun/Spec Holiday 0.00 0.00 Sun/Spec Hol. OT 0.00 0.00 Reg. Holiday 0.00 0.00 Reg. Holiday OT 0.00 0.00 Holiday/Leave 0.00 0.00 Night Premium 0.00 0.00 Meal Allowance 0.00 0.00 COLA (P28 Allow) 0.00 0.00 13th Month 0.00 Company Name Period : jul 09- July 22,2011 Name : John Lee Rate : 339.80 EARNINGS HRS AMOUNT Basic Pay 101 4289.96 Regular Overtime 0.00 0.00 Sun/Spec Holiday 0.00 0.00 Sun/Spec Hol. OT 0.00 0.00 Reg. Holiday 0.00 0.00 Reg. Holiday OT 0.00 0.00 Holiday/Leave 0.00 0.00 Night Premium 0.00 0.00 Meal Allowance 0.00 0.00 COLA (P28 Allow) 0.00 0.00 13th Month 0.00 Company Name Period : jul 09- July 22,2011 Name : Mary Ann Chan Rate : 339.80 EARNINGS HRS AMOUNT Basic Pay 90 3,882.75 Regular Overtime 0.00 0.00 Sun/Spec Holiday 0.00 0.00 Sun/Spec Hol. OT 0.00 0.00 Reg. Holiday 0.00 0.00 Reg. Holiday OT 0.00 0.00 Holiday/Leave 0.00 0.00 Night Premium 0.00 0.00 Meal Allowance 0.00 0.00 COLA (P28 Allow) 0.00 0.00 13th Month 0.00 I have a lot of employee so the data is long. I attach the format I want to happen. Thank you
Actually i already revised my code to change the design but still it was one side or one line. here is my code: {section name=att loop=$rs_label}[TABLE="class: stat"] [TD="colspan: 6, align: center"][B]{$rs_label[att].COMPANY_NAME}[/B][/TD] [TR] [TD="colspan: 3, align: center"][B]{$rs_label[att].fullName}[/B][/TD] [TD="colspan: 3, align: center"][B]{$rs_label[att].Rate}[/B][/TD] [/TR] [TD="colspan: 3"][B]{$rs_label[att].PERIOD} {$rs_label[att].FROM_DATE}-{$rs_label[att].TO_DATE}[/B][/TD] [TD="colspan: 3, align: center"][B]{$rs_label[att].RATE_Label}[/B][/TD] [TR] [TD="colspan: 3"][B]{$rs_label[att].EARNINGS}[/B][/TD] [TD="colspan: 3"][B]{$rs_label[att].DEDUCTIONS_Label}[/B][/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HRS}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].AMOUNT}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HRS}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].AMOUNT}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].BASIC_PAY_Label}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Reg_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Basic_Pay}[/TD] [TD="colspan: 1"]{$rs_label[att].Late_Label}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Late_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Late}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].REGULAR_OVERTIME}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].OTReg_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].OTReg_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].WITHHOLDING_TAX_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].TAX}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].SUN_SPEC_HOLIDAY}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].SunReg_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].SunReg_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].SSS_CONTRIBUTION_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].SSS}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].SUN_SPEC_HOL_OT}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].OTSun_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].OTSun_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].MEDICARE_CONT_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].PCHL}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].REG_HOLIDAY}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolReg_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolReg_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].HDMF_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HDMF}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].REG_HOLIDAY_OT}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolRegOT_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolRegOT_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].SSS_Loan_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].SSS_Amor}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].HOLIDAY_LEAVE}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolLeave_Hours_Tot}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HolLeave_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].HDMF_Loan_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].HDMF_Amor}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].NIGHT_PREMIUM_Label}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].NIGHT_PREMIUM}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].NP_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].TAX_ADJT_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].TaxAjt}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].MEAL_ALLOWANCE_Label}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].MEAL_ALLOWANCE}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Meal_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].Cash_Advance_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].CashAdvance}[/TD] [/TR] [TR] [TD="colspan: 1"]{$rs_label[att].COLA}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Cola_Hours}[/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Cola_Amt}[/TD] [TD="colspan: 1"]{$rs_label[att].Advances_Shirt_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].AdvanceShirt}[/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"]{$rs_label[att].Advances_Medical_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].AdvanceMed}[/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"]{$rs_label[att].Advances_Others_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].AdvanceOther}[/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"]{$rs_label[att].CANTEEN_Label}[/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].Canteen}[/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].LINE_Label}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].LINE_Label}[/TD] [/TR] [TR] [TD="colspan: 1"][B]{$rs_label[att].TOTAL_EARNINGS_Label}[/B][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][B]{$rs_label[att].TotalEarnings}[/B][/TD] [TD="colspan: 1"][B]{$rs_label[att].TOTAL_DEDUCTIONS_Label}[/B][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][B]{$rs_label[att].TotalDeductions}[/B][/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].Receipt_Pay}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].Receipt_Detail}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].Receipt_Detail1}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].Receipt_Detail2}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].fullName}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].FIRST_LINE}[/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [/TR] [TR] [TD="colspan: 3, align: center"]{$rs_label[att].SIGNATURE}[/TD] [TD="colspan: 1"][B]{$rs_label[att].TAKE_HOME_PAY_Label}[/B][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][B]{$rs_label[att].TakeHomePay}[/B][/TD] [/TR] [TR] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1"][/TD] [TD="colspan: 1, align: right"][/TD] [TD="colspan: 1, align: right"]{$rs_label[att].SECOND_LINE}[/TD] [/TR] [TR] [TD="colspan: 6"]{$rs_label[att].FOURTH_LINE}[/TD] [/TR] [/TABLE] {/section} Code (markup): I want is like thisPayslip Employee 1 Payslip Employee 2 Payslip Employee 3List of data1 List of data 2 List of data 3 And so on…Now the result of my code is ayslip Employee 1List of data1Payslip Employee 2List of data2 Payslip Employee 3List of data3Payslip Employee 4List of data4Payslip Employee 5List of data5Payslip Employee 6List of data6Thank you
Try this: <?php include 'config.php'; $sql = "SELECT DATE_FORMAT(d.FROM_DATE, '%M %c') AS FROM_DATE, DATE_FORMAT(d.TO_DATE, '%M %c, %Y') AS TO_DATE, g.EMP_NO, g.fullName, g.Rate, g.Reg_Hours, g.Basic_Pay, g.OTReg_Hours, g.SunReg_Hours, g.OTSun_Hours, g.HolReg_Hours, g.HolRegOT_Hours, g.HolLeave_Hours_Tot, SUM(g.NPReg_Hours + g.NPSun_Hours + g.NPHol_Hours) AS NIGHT_PREMIUM, SUM(g.MealReg_Hours + g.MealSun_Hours) AS MEAL_ALLOWANCE, g.Cola_Hours, g.Basic_Pay, g.OTReg_Amt, g.SunReg_Amt, g.OTSun_Amt, g.HolReg_Amt, g.HolRegOT_Amt, g.HolLeave_Amt, g.NP_Amt, g.Meal_Amt, g.Cola_Amt, p.COMPANY_NAME, p.PERIOD, p.NAME, p.FIRST_LINE, p.RATE_Label, p.EARNINGS, p.HRS, p.AMOUNT, p.BASIC_PAY_Label, p.REGULAR_OVERTIME, p.SUN_SPEC_HOLIDAY, p.SUN_SPEC_HOL_OT, p.REG_HOLIDAY, p.REG_HOLIDAY_OT, p.HOLIDAY_LEAVE, p.NIGHT_PREMIUM_Label, p.MEAL_ALLOWANCE_Label, p.COLA, p.13TH_MONTH, p.SECOND_LINE FROM $PAYROLL.casual_payslip_label p, $PAYROLL.casual_generate_payroll g, $PAYROLL.casual_date_upload d GROUP BY g.EMP_NO"or die(mysql_error()); $rs_label = $conn2->GetAll($sql); $smarty->assign('rs_label', $rs_label); $smarty->display('payslip.tpl'); $smarty->display('casual_payslip.tpl'); ?> <div> {section name=att loop=$rs_label} <table class="stat"> <tr> <td>{$rs_label[att].COMPANY_NAME}</td> <tr/> <tr> <td>{$rs_label[att].PERIOD} {$rs_label[att].FROM_DATE}-{$rs_label[att].TO_DATE}</td> <tr/> <tr> <td>{$rs_label[att].NAME} {$rs_label[att].fullName}</td> </tr> <tr> <td>{$rs_label[att].FIRST_LINE}</td> </tr> <tr> <td>{$rs_label[att].RATE_Label} {$rs_label[att].Rate}</td> </tr> <tr> <td>{$rs_label[att].EARNINGS} {$rs_label[att].HRS} {$rs_label[att].AMOUNT}</td> </tr> <tr> <td>{$rs_label[att].BASIC_PAY_Label} {$rs_label[att].Reg_Hours} {$rs_label[att].Basic_Pay}</td> </tr> <tr> <td>{$rs_label[att].REGULAR_OVERTIME} {$rs_label[att].OTReg_Hours} {$rs_label[att].OTReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].SUN_SPEC_HOLIDAY} {$rs_label[att].SunReg_Hours} {$rs_label[att].SunReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].SUN_SPEC_HOL_OT} {$rs_label[att].OTSun_Hours} {$rs_label[att].OTSun_Amt}</td> </tr> <tr> <td>{$rs_label[att].REG_HOLIDAY} {$rs_label[att].HolReg_Hours} {$rs_label[att].HolReg_Amt}</td> </tr> <tr> <td>{$rs_label[att].REG_HOLIDAY_OT} {$rs_label[att].HolRegOT_Hours} {$rs_label[att].HolRegOT_Amt}</td> </tr> <tr> <td>{$rs_label[att].HOLIDAY_LEAVE} {$rs_label[att].HolLeave_Hours_Tot} {$rs_label[att].HolLeave_Amt}</td> </tr> <tr> <td>{$rs_label[att].NIGHT_PREMIUM_Label} {$rs_label[att].NIGHT_PREMIUM} {$rs_label[att].NP_Amt}</td> </tr> <tr> <td>{$rs_label[att].MEAL_ALLOWANCE_Label} {$rs_label[att].MEAL_ALLOWANCE} {$rs_label[att].Meal_Amt}</td> </tr> <tr> <td>{$rs_label[att].COLA}{$rs_label[att].Cola_Hours} {$rs_label[att].Cola_Amt}</td> </tr> <tr> <td>{$rs_label[att].SECOND_LINE}</td> </tr> </table> {/section} </div> Code (markup):