Embedding FM Field data as URL using FX

[thebloke]

I am trying to add a php query to filemaker as a section on my training page.

The database contains a list of movie urls and titles.

I have successfully generated the list by modifiying the index.php that is included with the FX installation.

My problem is that when trying to make the Title into a clickable Link I am getting the following parse error.

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /Library/WebServer/Documents/FX/index1.php on line 86

here is line 86

code

echo "<a href=" . urlencode($value['URL'][0]) . "">";

echo $value['URL'][0];

echo "</a></td>n";

For clarity, I will add the code that does work (returns a list of movie urls but without the correct href

code

echo "<a href="detail.php?ID=$recordID&query=" . urlencode($currentSearch) . "">";

echo $value['URL'][0];

If anyone can shed some light on how I can make the data from the URL field in FileMaker be the href in the link I would be most appreciative.

thanks

John

FileMaker Version: 6

Platform: Mac OS X Panther