SRL Archive - Web Development

MySQL to be exact but doesn't seem to matter in this case


SELECT i.id, i.name, c.datetime, c.s_ID, c.qty, i.price, i.price * c.qty as 'TAmount' FROM cart c INNER JOIN items i ON i.id = c.id WHERE s_ID='$p_id';


Is there a way to sum all the TAmounts in the statement?

similar to how I multiplied price and quantity (qty) together and made them into 'TAmount' I was thinking maybe I could take all the TAmount's and just add them all together

thanks

SELECT i.id, i.name, c.datetime, c.s_ID, c.qty, i.price, SUM(i.price * c.qty) as TAmount FROM cart c INNER JOIN items i ON i.id = c.id WHERE s_ID='$p_id';

I am beyond lost as to why SUMing those removes all the other stuff

I assume because the SUM of price * qty is only one line so it forces itself to only display on a single line?

It's because of the INNER JOIN, I believe. Try a LEFT.

From: Kyle Undefined
It's because of the INNER JOIN, I believe. Try a LEFT.

Yea that messes it up for me, I just gave up and did a double query

[PHP]$query1="SELECT i.id, i.name, c.datetime, c.s_ID, c.qty, i.price, i.price * c.qty as 'TAmount' FROM cart c INNER JOIN items i ON i.id = c.id WHERE s_ID='$p_id'";

$query2="SELECT i.id, i.name, c.datetime, c.s_ID, c.qty, i.price, SUM(i.price * c.qty) as 'STAmount' FROM cart c INNER JOIN items i ON i.id = c.id WHERE s_ID='$p_id'";


$result1=mysql_query($query1);

$result2=mysql_query($query2);


$num=mysql_numrows($result1);
$num2=mysql_numrows($result2);

mysql_close();[/PHP]


Done with this final project already put plenty of work in it, thanks for your guys help though… Didn't think about SUMing the two while multiplying, didn't know that worked how it does, but looks like it's up and running

should probably convert to mysqli later so I don't have to do the ugly double query


yepp looks like all pages are working perfectly, thanks!

Use PDO or some ORM lib.