Hello -

I added links in a column which go to another page with an update form which is supposed to populate with the record, but the fields are not filling in.

Here is the link from a hand-coded table (not in Joomla) which passes the record to the form successfully:

<a href="update.php?id=<?php echo $row_rs_list['id']; ?>">Update</a>

These are some of the links I tried:

<a href="index.php?option=com_content&amp;view=article&amp;id=59&amp;catid=84&amp;catid=75?recordId={$columns:ID}" target="_blank">{$value}</a>

<a href="index.php?option=com_content&amp;view=article&amp;id=59&amp;catid=84&amp;catid=75?recordId={$columns:id}" target="_blank">{$value}</a>

<a href="index.php?option=com_content&amp;view=article&amp;id=59&amp;catid=84&amp;catid=75?id={$value}" target="_blank">View</a>

<a href="index.php?option=com_content&amp;view=article&amp;id=59&amp;catid=84?recordId={$columns:id}<?php echo $row_rs_list['id']; ?>" target="_blank">{$value}</a>

<a href="index.php?option=com_content&amp;view=article&amp;id=59&amp;catid=84?recordId={$columns:id}<?php echo $_REQUEST['id']; ?>" target="_blank">{$value}</a>

The data entry form works fine, so I know the db connection is good.

Am I missing something here? Please, if anyone has got this to work before, please let me know.

Thank you.

Hello,

Do you want to pass value of "id" field to update.php script or to article with ID = 59?

Regards,
ARI Soft

Hi -

There is no update.php now - that was before I put the form in a Joomla article.

84 is the category ID for the article.
59 is the article ID.
The $value reflects the person's last name.
I think recordId must reflect the record number in the ARI Data Table, but in my database I'm using 'id'.

I need for the record from that 'id' to populate the form in the article.

Thank you -
wilway

Use the following code:

<a href="index.php?option=com_content&view=article&id=59&catid=84&recordId={$columns:id}" target="_blank">{$value}</a>

Regards,
ARI Soft

Thanks, but I tried and it didn't work.

Check your script in the article. Probably it doesn't work with request variables ("id" request variable in your case).

Regards,
ARI Soft