Adding Fields

billcoker

I knew the day would come when I need this.

<b>table structure:</b> <br>

CREATE TABLE cart (
cart_id mediumint(9) NOT NULL auto_increment,product_id mediumint(9) DEFAULT '0' NOT NULL,
product_name varchar(40) NOT NULL,
product_price varchar(10) NOT NULL,
uid varchar(30) NOT NULL,
PRIMARY KEY (cart_id)
);

product_price will = something like $200.00

I need a way to get and display the total of
product_price for the uid in the table.

In other words select all and total up all the product_price fields for uid=127.0.0.1999445629

Math is my weakest link in php and mySQL.

This is for a simple cart and speed of the code is not a concern. Just needs to be simple way of doing it.

Really hope someone can help.

Thanks,

Bill Coker.

Anon

select sum(product_price) as total_product_price where uid=127.0.0.1999445629

billcoker

Thasks,

Sorry to bother you again. I must be doing it wrong.

I am getting this error:

No data.
Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\shoptest\total.php on line 32
line 32 = mysql_free_result($result);

It's not get the value I think. There are 5 records with the uidbelow.

Here is my code:

<?
mysql_connect('','','') or die ("Problem connecting to DataBase");

$query = "select sum(product_price) as total_product_price where uid=127.0.0.1999456484";

$result = mysql_db_query("shoptest", $query);

if ($result) {

while ($r = mysql_fetch_array($result)) {

$product_id = $r["product_id"];
$product_number = $r["product_number"];

$product_category = $r["product_category"];
$product_short = $r["product_short"];
$product_flypage = $r["product_flypage"];

$product_name = $r["product_name"];
$product_msrp = $r["product_msrp"];
$product_price = $r["product_price"];

$product_stock = $r["product_stock"];
$product_thumbimage = $r["product_thumbimage"];
$product_flyimage = $r["product_flyimage"];

echo "$total_product_price";

}
} else {
echo "No data.";
}
mysql_free_result($result);
?>

mithril

Bill,

You need to enclose the uid value you're querying on in quotes since it's a string value. For example:

$query = "select sum(product_price) as total_product_price where uid='127.0.0.1999456484'";

HTH.

geoff

billcoker

Travis,

I did.
$query = "select sum(product_price) as total_product_price where uid='127.0.0.1999456484'";

Any ideas?

Bill.

brainiac

$query = "SELECT SUM(product_price) AS total_product_price FROM cart WHERE uid='127.0.0.1999456484'";
If that does not work maybe it's because all the prices are prefixed with a dollarsign ($) ?
else try something like:
mysql_db_query("shoptest",$query);
if (mysql_errno != 0) {
echo "MySQL error: ".mysql_errnr()." : ".mysql_error;
}
To get the error messages from MySQL printed out.