php query question
so there may be 20 different entries for the same car.id how can I query the table to return all the bills per car.id ADDED up and spit out ONE total
I'm using this query right now
SELECT * FROM `cars` JOIN `bills` ON cars.id=bills.car_id WHERE cars.make="$userchoice" ORDER BY cars.year DESC
this is returning about 20 copies of the same vehicle with each bill how can I get ONE total in the cost colum and one copy of the vehicle
The 2nd Amendment, 1789 - The Original Homeland Security.
Gun control means never having to say, "I missed you."
The 2nd Amendment, 1789 - The Original Homeland Security.
Gun control means never having to say, "I missed you."