Wrong output of after I sum the data from database

Question

Let say I wan to sum up the Duration in my leave table and with condition Leave_Type = 'Annual' and Status = 'Approved'

My database

table leave
{Leave_ID(PK), Leave_Type, Status, Duration, Emp_ID(FK)}

table employee
{Emp_ID(PK), Emp_Name}

I use the following code to sum the Duration

$aid=$_SESSION["eid"];

$Annual = mysql_query("select SUM(Duration)

FROM `leave`

WHERE leave.Leave_Type = 'Annual' and leave.Status = 'Approved' 
and leave.Emp_ID = employee.Emp_ID and leave.Emp_ID = $aid");

The way i display the output

<td><?php echo $Annual;?></td>

But the output I get is something like "Resourse id#4". That's not the output I want and it should be the total sum of duration. Is there is any problem with mysql_query or the way i print my output?

What is the type of the duration column? Integer, Datetime? — Tikkes
– Tikkes, Commented Sep 2, 2013 at 9:03
Your query filters by employee.Emp_ID but doesn't read employee. It's impossible that it returns any output: it must be crashing. — Álvaro González
– Álvaro González, Commented Sep 2, 2013 at 9:13

Lwyrn · Accepted Answer · 2013-09-02 09:10:44Z

1

You are doing wrong the output!

$AnnualData = mysql_fetch_assoc($Annual);

Than the output:

<td><?php echo $AnnualData['SUM(Duration)'];?></td>

If you want you can add an alias to the sum statement like this ( in the sql query ):

SUM(Duration) AS total

and than output like this:

<td><?php echo $AnnualData['total'];?></td>

edited Sep 2, 2013 at 9:10

answered Sep 2, 2013 at 9:05

Lwyrn

1,9311 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tikkes Over a year ago

Better yet, put a name on the field. SUM(Duration) as leaveDuration and retrieve it as $AnnualData['leaveDuration']

Gerben Jacobs · Accepted Answer · 2013-09-02 09:06:23Z

0

You're only running the query, you need to fetch the data.

Change mysql_query to mysqli_query (the former one is deprecated) and then use mysqli_fetch_assoc($Annual)

answered Sep 2, 2013 at 9:06

Gerben Jacobs

4,6134 gold badges36 silver badges56 bronze badges

Comments

MarkTWebsite · Accepted Answer · 2013-09-02 09:06:36Z

0

You should add;

$annual2 = mysql_fetch_array($annual);

then

<?PHP echo $annual2['Duration']; ?>

Hope this helps :)

answered Sep 2, 2013 at 9:06

MarkTWebsite

211 silver badge3 bronze badges

3 Comments

Tikkes Over a year ago

This will not work as you are selected the SUM of Duration and not Duration itself

MarkTWebsite Over a year ago

Okay then, add $annual3 = SUM($annual2['duration'];

Tikkes Over a year ago

I'm sorry but no, look at the query and the answer Lwyrn gave earlier.

Kalpit · Accepted Answer · 2013-09-02 09:16:03Z

0

$query=mysql_fetch_array($Annual);

echo $query[0];

it will print what you want exactly...

answered Sep 2, 2013 at 9:16

Kalpit

4,9365 gold badges27 silver badges45 bronze badges

Collectives™ on Stack Overflow

Wrong output of after I sum the data from database

4 Answers 4

1 Comment

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related