8 replies to this topic

[shiyam198]

Hi Guys,

The following segment of code (below) is to create a drop down menu from the "lkgroup" column from the table - lk_group.

But it is giving me the error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Any help is appreciated.

Thanks,
Shiyam

<SELECT NAME="group">
<?php
while($row = mysql_fetch_array( $result ))
{
echo "<option VALUE=\"$row[\'lkgroup\']\">$row[\'lkgroup\']</option>";
# echo $row['lkgroup']. "<br/>";
}
?>
</SELECT>

Edited by John, 31 August 2008 - 09:33 PM.
Please use [code] or [php] tags when posting code.

[John]

while($row = mysql_fetch_array( $result ))

{

echo "<option value={$row['lkgroup']}>{$row['lkgroup']}</option>";

# echo $row['lkgroup']. "<br/>";

}

Please use the [php] [ /php] bbtags when posting php code.

[chili5]

echo "<option VALUE=\"$row[\'lkgroup\']\">$row[\'lkgroup\']</option>";

Why are you escaping all the ' characters? In fact, I don't really think you need those, because of the double quotes.

echo "<option value=\"$row[lkgroup]\">$row[lkgroup]</option>";

You could also write it like:

echo "<option value=\"" . $row['lkgroup'] . "\">" . $row['lkgroup'] . "</option>";

You don't need to escape the ' characters unless your starting your echo statement with '.

[shiyam198]

Thank you Sir. Your last suggestion worked fine.

[Xav]

Ya see, chil, he called you Sir. :D

[ArtoStiloz]

shiyam198 said:

Thank you Sir. Your last suggestion worked fine.

What about 2. Suggestion?

[morefood2001]

I believe that using a single ' will work, however I prefer using ". ." in this case.

echo "<option value=\"'$row[lkgroup]'\">'$row[lkgroup]'</option>";

[John]

What about the ' inside $row[lkgroup]? As in $row['lkgroup']

[morefood2001]

John said:

What about the ' inside $row[lkgroup]? As in $row['lkgroup']

That obviously won't work, thanks for pointing that out.