I try to insert the code below as html message to email any client but I always get this:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

I know i must covert " to ' but mysql is always having trouble

PHP Code:

$html_message ="<td height='12' bgcolor='#FFFFFF'><p align='center'>ITEM(s) ORDERED</p>
    <table width="229" border="0">
    <tr>
      <td width="10">&nbsp;</td>
      <td width="77"><div align="center">ITEM</div></td>
      <td width="59"><div align="center">QTY</div></td>
      <td width="65"><div align="center">PRICE</div></td>
    </tr>
    <?php
    include('admin_config.php');
    $visitid = getenv('REMOTE_ADDR');
$query21  = 'SELECT * FROM cart WHERE visitid='$visitid'';
$result21 = mysql_query($query21);
while($row = mysql_fetch_assoc($result21))
{ 


$qty1 = $row['qty'];
$code1 = $row['code'];
    
    ?>
    
    <tr>
      <td></td>
      <td><div align="center"><?php echo $row['code']; ?></div></td>
      <td><div align="center"><?php echo $row['qty']; ?></div></td>
      <td><div align="center">$ <?php 
$query1  = 'SELECT * FROM item WHERE code='$code1'';
$result1 = mysql_query($query1);
while($row = mysql_fetch_assoc($result1))
{    
$price = $row['price'];
echo $price;
//$stocks = $row['$stocks'];
} ?></div></td>
    </tr><?php  
$sub = $qty1 * $price;
$total = $total + $sub;
    } ?>
  </table>";

mail($receiver, $subject, $html_message,$header);

You have not parsed the output, so your PHP injecting yourself. looking into the htmlentities() function ( http://uk2.php.net/manual/en/function.htmlentities.php ).

Also, does it say what line the error occurs?

I don't see where you close $html_message so that's probably a problem as well. It does look like you have unescaped " inside that variable.

Also, you might want to do queries and such before starting to output to the string.

I forgot to mention that error appears in line

$qty1 = $row['qty']; <-- error message as stated on first post

You had some major syntax errors in a bunch of places. I fixed them for you but just so you know generally queries are done in " with ' used for variables like:

PHP Code:

$query = "SELECT whatever FROM table WHERE item = '$thing'"; 


You also had some issues with closing your ?> then not opening it up again to actually do the mail function. It should be all cleaned up now =)

PHP Code:

<?php
$html_message ='<td height="12" bgcolor="#FFFFFF"><p align="center">ITEM(s) ORDERED</p>
    <table width="229" border="0">
    <tr>
      <td width="10">&nbsp;</td>
      <td width="77"><div align="center">ITEM</div></td>
      <td width="59"><div align="center">QTY</div></td>
      <td width="65"><div align="center">PRICE</div></td>
    </tr>';
    include('admin_config.php');
    $visitid = getenv('REMOTE_ADDR');
$query21  = "SELECT * FROM cart WHERE visitid='$visitid'";
$result21 = mysql_query($query21);
while($row = mysql_fetch_assoc($result21))
{ 


$qty1 = $row['qty'];
$code1 = $row['code'];
    
    ?>
    
    <tr>
      <td></td>
      <td><div align="center"><?php echo $row['code']; ?></div></td>
      <td><div align="center"><?php echo $row['qty']; ?></div></td>
      <td><div align="center">$ <?php 
$query1  = "SELECT * FROM item WHERE code='$code1'";
$result1 = mysql_query($query1);
while($row = mysql_fetch_assoc($result1))
{    
$price = $row['price'];
echo $price;
//$stocks = $row['$stocks'];
} ?></div></td>
    </tr><?php  
$sub = $qty1 * $price;
$total = $total + $sub;
    } ?>
  </table>";
<?php
mail($receiver, $subject, $html_message,$header);php



?>

Thanks! I will have a try on this.... thanks alot for the help =)