[SOLVED] results from DB not correct

[dennismonsewicz]

Code:

 

foreach($deduct_rows as $rows) {
					echo '<div style="padding-top:20px;">';
						echo '<span class="maintitle" style="font-size: 30px !important; display: block;">Your deductible is $'. $rows->deductible .'</span>';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 20px;">Your bundle price is $' . $rows->bundle . '</span';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 10px;">Your insurance price is $' . $rows->insurance . '</span';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 10px;">Your warranty price is $' . $rows->warranty . '</span';
					echo '</div>';
				}

 

The results come back as the following: $.99 when in the DB the actual row is 5.99

 

So its cutting off the first character.... any ideas?

[KevinM1]

You're echoing out four distinct values...are they all screwed up, or just one of them?

[dennismonsewicz]

All of them... and if I print_r($rows); then the results display as they should. For some reason the Span tag is messing everything up

[J.Daniels]

'</span';

 

You are missing the closing bracket on 3 lines.

[dennismonsewicz]

yeah I noticed that and that didn't fix the problem

 

updated code:

 

foreach($deduct_rows as $rows) {
					echo '<div style="padding-top:20px;">';
						echo '<span class="maintitle" style="font-size: 30px !important;">Your deductible is $' . $rows->deductible . '</span>';
echo $rows->deductible;
					echo '</div>';
				}

 

If I echo out the deductible and it is not inside the span tag then everything displays like it should

[J.Daniels]

Can you do a view source and post the generated output?

[dennismonsewicz]

<div class="maintitle" style="font-size: 30px ! important;">Your Deductible is .00</div>

 

I have it boiled down to if I include an HTML $ symbol then it doesn't display the characters before the decimal for some reason

[dennismonsewicz]

I got it fixed. I had to escape the $ symbol

 

updated code:

 

foreach($deduct_rows as $rows) {
					$deduct = $rows->deductible;
					echo '<div style="padding-top:20px;">';
						echo '<span class="maintitle" style="font-size: 30px !important; display: block;">Your deductible is \$'. $rows->deductible .'</span>';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 20px;">Your bundle price is \$' . $rows->bundle . '</span>';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 10px;">Your insurance price is \$' . $rows->insurance . '</span>';
						echo '<span class="maintitle" style="font-size: 20px; !important; display: block; padding-top: 10px;">Your warranty price is \$' . $rows->warranty . '</span>';
					echo '</div>';
				}

[JJ2K]

Dont you need to escape the dollar symbol like \$

 

EDIT: Sorry to slow