Link from an image

Hello Ray
I have been having some problems creating links on pages so decided to go back to basics.
To create pages with links what could be better than to use the
DW Top menu bar - WebAssist - Database - DataAssist Pages.
So there I created The pages Search - Results - Details and all works very well.

One item I wish to change is the dynamic link to go from Results to Details. This is a Magnifying Glass and I wish to use a Field such as the record number or an image.
I tried to adapt the magnifying glass code but could not get this working.
Can you please provide a sample?

I am attaching files

Many thanks

John

Just create a link with:

<a href="mydetails.php?RecNo=<?php echo($WADAboats->getColumnVal("RecNo")); ?>">link text here</a>

Hi Ray,
This is most peculiar in boat-details.php I have directed the link to boatenquiry_insert.php
Link is now
<a href="Enquiries/boatenquiry_insert.php?RecNo=<?php echo($WADAboats->getColumnVal("RecNo")); ?>">

When I run index.php/boat-details.php the link text disappears along with anything below the link.

(I would prefer a button working).
I am attaching the file.
Thanks
John

Your recordset is named: $WADAboats_details

not: $WADAboats

So the getColumnVal() reference has to be updated to use a recordset name that is defined on the page.

Thanks Ray the link now works fine.
I did try to adapt the link code into the button but would you believe no joy?
Can you please show me what it should be?
I have attached the file.
Many thanks
John

Hi Ray
I have pasted the code sent
<button type="button" onclick="document.location.href='Enquiries/boatenquiry_insert.php?RecNo=<?php echo($WADAboats->getColumnVal("RecNo")); >'">click here</button>
in the page, but it is not working also seems to introduce a syntax error at line 336 and lose some of the code when I paste it in.

I am attaching a picture and the file.

Regards
John

That isn't the same as the code I provided.... it should be:

<button type="button" onclick="document.location.href='Enquiries/boatenquiry_insert.php?RecNo=<?php echo($WADAboats->getColumnVal("RecNo")); ?> >'">click here</button>

You have:

<button type="button" onclick="document.location.href='Enquiries/boatenquiry_insert.php?RecNo=

                  <?php echo($WADAboats->getColumnVal("RecNo")); >'">click here</button>

Make sure you copy from the forum post on the web and not your email. Email clients can change the text and make it unusable.

Hi Ray,
I copied the code from above but still have a problem.

I have created 3 attachments which should show the result.
Image 1 shows wth new code
Image 2 shows without new code

Many thanks
John

You have button code:
$WADAboats->getColumnVal("RecNo")

but your recordset is named: WADAboats_details

So the code should be:
$WADAboats_details->getColumnVal("RecNo")