cant embed html into ifelse statement

[garycarr]

I am trying to embed some html into a ifelse statement that will echo some text. The following is my code along with the error I get. This is in a template file.

<tr>
<td><b><?php echo $text_price; ?></b></td>
<td>
<?php
$map = 'Add to Cart to See Price';
$result = mysql_query("SELECT map FROM oc_product where product
while($row = mysql_fetch_array($result))
if ($row['map'] == 1)
<span style="color: #F00;"> echo $map;</span>
elseif (!$special) {
echo $price; }
?>
<?php } else { ?>
<span style="text-decoration: line-through;"><?php echo $price;?></span> <span style="color: #F00;"><?php echo $special; ?></span>
<?php } ?></td>

            </td>
        </tr>                          

[root@www product]# php product.tpl
PHP Parse error: syntax error, unexpected '<' in product.tpl on line 25

I've worked on this for 2 days now. I can make the script work without the html. Can someone point in the right direction?

[paulnaj]

Hi Gary,

It's a bit of a mess, I'm afraid ... here's s cleaned-up version but I can't tell from your code exactly what the logic is, but you should be able to adapt to fit.

One definite oddity is the SQL statement - it's been chopped at the end so you need to fix that

<tr>
	<td><b><?php echo $text_price; ?></b></td>
	<td>
<?php
$map = 'Add to Cart to See Price';
$result = mysql_query("SELECT map FROM oc_product where product XXX"); // something missing here XXX
while($row = mysql_fetch_array($result)){
	if ($row['map'] == 1){
?>
		<span style="color: #F00;"><?php echo $map;?></span>
<?php 
	} else if($special){
?>
		<span style="text-decoration: line-through;"><?php echo $price;?></span>
		<span style="color: #F00;"><?php echo $special; ?></span>
<?php 
	} else { 
		echo $price; 
	}
}
?>
	</td>
</tr> 

Paul

PS
Try being a bit more methodical when laying out the code - makes for an easier read and understanding (especially later).

[CoderDan]

I added a few bracers for clarification of code, try this:

<tr>
	<td><b><?php echo $text_price; ?></b></td>
	<td>
<?php
$map = 'Add to Cart to See Price';
$result = mysql_query("SELECT map FROM oc_product where product "); // what is the end of this query?
while($row = mysql_fetch_array($result))
{
	if ($row['map'] == 1)
	{
		echo '<span style="color: #F00;">' . $map . '</span>';
	}
	elseif (!$special)
	{
		echo $price;
	}
	else
	{
?>
<span style="text-decoration: line-through;"><?php echo $price;?></span> <span style="color: #F00;"><?php echo $special; ?></span>
<?php
	}
}
?></td>
</tr>

also, where are you getting $price, $special and $map from? they aren't supposed to be $row['price'], $row['special'], $row['map'] are they?

[garycarr]

Hi, thanks for the help guys. Both of these scripts worked like a charm. The sql was stripped when I did the copy and paste.