Hello Ray
In the past i have created many links but at the moment I do not seem able.
This seems to have occoured after updating to DB 234, I must now be making some basic mistakes.
Is ther a tutorial anywhere for this. I found one of JB's but it was many yearsold now and out of date.
To try to understand where I am going wrong I copied my steps.
I create a link on the list.php named Details
Link box shows details.php
On the right hand side Of the link box there is a folder.
I select the folder and use the Data Sources tab to select RecNo
This produces code on the list.php page of
<a href="<?php echo($rsCanalBoatList->getColumnVal("RecNo")); ?>">Details</a>
It appears the target of page Details.php is missing.
When I hover over the link I see http://localhost/boatsforsalenow_mysqli/categories/119898
I can correct this by inserting detail.php
reating <a href="details.php<?php echo($rsCanalBoatList->getColumnVal("RecNo")); ?>">Details</a>
which arrives at the correct page.
On the details.php page I deleted the recordset to insert a new one.
I selected Query builder (which seems very slow) and dragged the boats table
I select the few column names required.
After this I selected Advanced Builder
I selected Where RecNo comparison value is set to URL Parameter and I entered RecNo in the box and OK.
On the page this brought up a syntax error on line 4
I deleted the recordset and reset the page
I created a new recordset rsDetails in Simple format
with RecNo Url Parameter and RecNo
I then selected Advanced
I selected Edit in the Variables Column whci showed
Colname Interger -1 $_GET['RecNo'] I selected OK and OK again
==================================================================
When I ran the pages
The url shows on the List page appears to be correct and when I press the link
the url shows as http://localhost/boatsforsalenow_mysqli/categories/details.php11898
which is also correct
But I get the error
Object not found!
========================
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated.
Please inform the author of that page about the error.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.29 (Win32) OpenSSL/1.0.2l PHP/5.6.32
============================
I have placed the files at
http://net100test.co.uk/WA_DB234/BFSN_full/categories/list.php
ftp detail
Ftp Detail
Server: home415519235.1and1-data.host
Port: 22
Protocol: SFTP
User name u68925687-Mysqli_tes
Password P0lyg0n&20*&
I think when I get clear on the system of getting the links to work
I will publish the method on the forum to help me if ever I get into a pckle again.
(If that is Ok)