104 replies to this topic

[Xav]

Hey guys, can you help me?

Welcome to Stav Cinemas

At the moment, the code is this:

<?php


$result = mysql_query("SELECT (COUNT(bookings.orderID) * prices.priceCost) AS price, customerFirstName, customers.priceID FROM bookings, customers, prices WHERE bookings.custID = customers.customerID AND customers.priceID = prices.priceID GROUP BY bookings.custID, customers.customerID");


while ($row = mysql_fetch_array($result))

{

echo $row["customerFirstName"] . " " . $row["price"] . "<br />";

}


?>

You can see the output in the link.

The number next to each person is how much they have spent on the site in total. Now, how do I total this all up in the SQL query (the while loop will have to go once there's a single piece of data)?

[Xav]

Anyone at all?

[Brandon W]

Mate. I would love to help you but I am still in the process of learning MySQL. But from what I can understand.

Couldn't you store each of the prices in an array, then using a loop add them all together and then print the answer?

[Xav]

Yes, but that is slow and inefficient. Doing it in the SQL is much faster and cleaner.

Anyone, please?

[Brandon W]

OK well then I can't, sorry mate.

[Xav]

Dang. :( Winged?

[Brandon W]

PM him and get him to visit this thread.

[Xav]

I already tried that, it didn't work. Hmm...

[Brandon W]

Does it show an error or just doesn't show anything at all?

[Xav]

The MySQL query becomes invalid.

Anyway, I couldn't be bothered to spend time on it, so I just ditched the SQL countup and did it in a PHP loop as you suggested. It can be viewed at Welcome to Stav Cinemas and no, that money is not real.

[Xav]

The MySQL query becomes invalid.

Anyway, I couldn't be bothered to spend time on it, so I just ditched the SQL countup and did it in a PHP loop as you suggested. It can be viewed at Welcome to Stav Cinemas and no, that money is not real.