I am new to PHP, pl help me.

smbkgeo1983

I m using PHP and mysql and i have created a table named dailyreports and it also the final php file, and it has 4 files as

dailyreportsadd.php
dailyreportsinfo.php
dailyreportslist.php
dailyreportsview.php

Now all i have to do is i have to subtract 2 fields, can someone help me.

I have 3 fields called # of agents rostered, # of agents present, Absent (in nos)

Now my clarifiaction is where can i define the formula, so that my result page should look like Absent (in nos)=# of agents rostered-# of agents present

Where should I define this formula?

Thanks,
Balakrishnan.

halojoy

hard to say

You have the CREATE TABLE sql ?
What are the exact column fields of your table.

You have some code from the page where this Data you mention
is pulled from MySQL with a query ?

smbkgeo1983

Hi halojoy,

Thanks for your reply,

Emails Handled (manual)
Emails Handled (RN)
Oldest Email (in days from last updated)
NAV
NIS
NSW
N360
SEA
Daily Capacity (as per binding)

of agents rostered

of agents present

Absent (in nos)
Absenteeism (in %)
Transfer to CS from TS
Transfer to TS from CS
OoS%
Surveys
CSAT
R2C Ratio
Scheduled Staff hours (rostered * 8 hours)
Seats utilized

These r the fields that I have in the table.

I have named the table as tsemail_chennai

If you want any specific files to be uplocaded, just tell me, so that I can upload it for your reference.

Please help.

Thanks,
Balakrishnan.