[SOLVED] Small syntax problem

[psychowolvesbane]

I have this script:

 

<?php 
   $conn = mysql_connect('$host','$username','$password');

    $db = mysql_select_db('$dbname', $conn);

    $sql = "SELECT ItemType FROM ItemType ORDER BY ItemType";
  
    $rs = mysql_query($sql, $conn) or die(mysql_error());
    
    $X=0;
   
    while($row = mysql_fetch_array($rs))
    {
       echo"<option value='$X'>$row['ItemType']</option>"; (Line 55)
       $X=$X+1;
    }
    mysql_close($conn);
?>

 

I get this error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/www/psychowolvesbane.freehostia.com/admin/add_product_form.php on line 55

 

Can anyone tell me how i am echoing wrongly on Line 55?

 

P.S. I already have the open and close tags for the Select list form item, just on the outside of this code.

[trq]

<?php 
   $conn = mysql_connect('$host','$username','$password');

    $db = mysql_select_db('$dbname', $conn);

    $sql = "SELECT ItemType FROM ItemType ORDER BY ItemType";
  
    $rs = mysql_query($sql, $conn) or die(mysql_error());
    
    $X=0;
   
    while($row = mysql_fetch_array($rs))
    {
       echo "<option value='$X'>{$row['ItemType']}</option>";
       $X++;
    }
    mysql_close($conn);
?>

[psychowolvesbane]

No, I tried your code and it still came up with the same error, is there non echoing method to try?

 

e.g.

 

?>

<option val...>

<?php

[Ken2k7]

<?php 
   $conn = mysql_connect('$host','$username','$password') or die(mysql_error());

    $db = mysql_select_db('$dbname', $conn) or die(mysql_error());

    $sql = "SELECT ItemType FROM ItemType ORDER BY ItemType";
  
    $rs = mysql_query($sql, $conn) or die(mysql_error());
    
    $X=0;
   
    while($row = mysql_fetch_assoc($rs))
    {
       echo"<option value='$X'>{$row['ItemType']}</option>";
       $X=$X+1;
    }
    mysql_close($conn);
?>

[wildteen88]

There is no errors with the code thorpe provided. The error must be coming from somewhere else within your code. Can you post lines 45 - 60 here from add_product_form.php

[psychowolvesbane]

Nevermind I got it using that code, just missed out the connect DB while copying codes around.