multiply help

[medic61]

Hey everyone, I'm fairly new to this, can adjust an existing script for the most part, but need help with something.

I want to be able to say, if MSRP is 0-$10, display same, if $10.01-$25.00 then .90, if $25.01-$50.00 .75, everything else is *.70.

Here's my code that I'm starting with:

$number= $row['MSRP'] * .79;
$formatted = number_format($number,2);
$content .= $formatted."\t";

This didn't work as I was trying to get it to round.? Can someone help?

Thanks soooo much.

Shane

[gardnc]

Try
$formatted = round($number);

[gardnc]

or better yet

$formatted = round($row['MSRP'] * .79);

[medic61]

I'll try that, how about the if/then statements? Can you help with that?

[bradgrafelman]

if($row['MSRP'] > 0 && $row['MSRP'] <= 10) {
 ...
} elseif($row['MSRP'] > 10 && <= 25) {
 ...
} elseif($row['MSRP'] > 25 && $row['MSRP'] < 50) {
 ...
} // etc. etc. etc.

[medic61]

This is what I have, trying to follow your code:

if($row['MSRP'] > 0 && $row['MSRP'] <= 10) {
$content .= $row['MSRP']."\t"};
elseif($row['MSRP'] > 10 && <= 25) {
$content .= $row['MSRP'] .90};
elseif($row['MSRP'] > 25 && $row['MSRP'] < 50) {
$content .= $row['MSRP'] .80
};

It errors on me. Yikes! LOL

[bradgrafelman]

Don't forget to use [PHP] tags, it makes the code easier to read. (Had to add a slash, otherwise the bbcode script tried to parse it as an actual tag! :p)

Looks like you need a quick lesson on semicolons! 🙂

if($row['MSRP'] > 0 && $row['MSRP'] <= 10) { 
$content .= $row['MSRP']."\t";
}

You don't terminate braces ( {} ) with semicolons, but you DO terminate all of the statements inside.

[medic61]

Thanks for your help! my first time with {} (believe it or not). Here's what I have and it works:

if($row['MSRP'] > 0 && $row['MSRP'] <= 10) {
$content .= $row['MSRP']."\t";}
elseif($row['MSRP'] > 10 && $row['MSRP'] <= 25) {
$content .= $row['MSRP'] .90."\t";}
elseif($row['MSRP'] > 25 && $row['MSRP'] <= 50) {
$content .= $row['MSRP'] .80."\t";}
elseif($row['MSRP'] > 50) {
$content .= $row['MSRP'] * .75."\t";
}

Still stumped on the rounding, no matter where i put round(...), it doesn't work.

[bradgrafelman]

Rounding? Just do this:

$content .= round($row['MSRP'], 2)."\t";}
elseif($row['MSRP'] > 10 && $row['MSRP'] <= 25) { 
$content .= round( ($row['MSRP'] * .90) , 2)."\t";}

etc.

[medic61]

Excellent!!! Thank you soooo much. This will automate a lot of hand coding with excel!!

I appreciate your time.