getting a fetch(PDO::FETCH_OBJ) to print properly

Question

QWaz 0 Junior Poster in Training

14 Years Ago

Hi,

I am having a bit of trouble getting my fetch(PDO::FETCH_OBJ) to print the way I want. I am also unsure if fetch(PDO::FETCH_OBJ) is the right thing to use.

Code below.

$sqlTotal = "SELECT SUM(price) FROM `$user` WHERE `cart`=1";
	$total = $conn->query($sqlTotal);
	$total->execute();
	$totalResult = $total->fetch(PDO::FETCH_OBJ);
	$totalResult = print_r($totalResult);

It is printing out as: stdClass Object ( [SUM(offer)] => 58000 )
So the statement works.
But I only want '58000' to display or return.

How can I do this?

Thanks,

QWaz

perl php

1 Contributor
1 Reply
142 Views
6 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by QWaz

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

QWaz 0 Junior Poster in Training · Answer 1 · 2010-07-14T09:47:32+00:00

Hi,
I am having a bit of trouble getting my fetch(PDO::FETCH_OBJ) to print the way I want. I am also unsure if fetch(PDO::FETCH_OBJ) is the right thing to use.
Code below.
$sqlTotal = "SELECT SUM(price) FROM `$user` WHERE `cart`=1";
	$total = $conn->query($sqlTotal);
	$total->execute();
	$totalResult = $total->fetch(PDO::FETCH_OBJ);
	$totalResult = print_r($totalResult);
It is printing out as: stdClass Object ( [SUM(offer)] => 58000 )
So the statement works.
But I only want '58000' to display or return.
How can I do this?
Thanks,
QWaz

ANSWER:

$sqlTotal = "SELECT SUM(price) FROM `$user` WHERE `cart`=1";
	$total = $conn->query($sqlTotal);
	$total->execute();
	$totalResult = $total->fetch(PDO::FETCH_NUM);
	$totalResult = $totalResult[0];