Dealing with money in MySQL & Joining Tables

[BCAV_WEB]

Hi,

 

I have a two parter question completely different.

 

1. I need to have two money figures saved to my database "RRP" and "our price" and with this I would like to work out the savings. Easy enough to do, however how do I get the int number to display as £4,567.00 for example?

 

[

$savings = $row["rrp"] - $row["our_price"];

]

 

2. Part two of my question I have a database that stores cars, so models makes etc... but I also need to store colours for each car, so the colour name and the colour colour. What would be the best way of doing this? Remembering that a single car can have many many colours.

 

Any ideas and thought would be much appericated.

 

Thank you

[fenway]

1. store proper DECIMAL fields, format on output only.

2. use a many-to-many relation table.

[BCAV_WEB]

But how do you do that?

[fenway]

Which one?

[BCAV_WEB]

Both how do you set the demical points in phpMyAdmin? And link two tables together?

[fenway]

The DECIMAL column type must be one of the options -- I've always used alter statements.

 

As for linking them together, you'll need 3 tables -- colors, cars, and the relation table.  Simply store a uid tuple in the latter.

[BCAV_WEB]

Okay, but how do you get the commas added in so "3000" would become "3,000" and maths would still be possible??

[fenway]

Okay, but how do you get the commas added in so "3000" would become "3,000" and maths would still be possible??

 

That's formatting for output -- leave the raw numbers alone.

[WilliamC]

As fenway said, do not bother with formatting until after all the math you want to do is done, after that number_format() is your friend for display output.

 

[BCAV_WEB]

Okay, do you know anyway to formatt the outputted data?

[WilliamC]

I already told you that...  number_format()