Thanks Ray
I have the List Page producing the url
localhost/boatsforsalenow_mysqli/categories/details.php?RecNo=11476
from the Details link on List.php
<a href="details.php?RecNo=<?php echo($rsCanalBoatList->getColumnVal("RecNo")); ?>">Details</a>
When the Details link is used it opens details.php but no records appear.
When the Recordset for the details.php is tested
with a RecNo inserted eg 11746 the correct detail appears.
I hope I have explained this OK for you.
The code for detail.php is below
<?php require_once('../Connections/conn1_i.php'); ?>
<?php require_once('../webassist/mysqli/rsobj.php'); ?>
<?php
$rsDetails = new WA_MySQLi_RS("rsDetails",$conn1_i,1);
$rsDetails->setQuery("SELECT RecNo, Manufacturer, Model, Category1, image1_900, Image1_250 FROM boats WHERE RecNo = ?");
$rsDetails->bindParam("i", "".(isset($_GET['".($rsDetails->getColumnVal("RecNo")) ."'])?$_GET['".($rsDetails->getColumnVal("RecNo")) ."']:"") ."", "-1"); //colname
$rsDetails->execute();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<p>Details <br />
<?php echo($rsDetails->getColumnVal("RecNo")); ?><br />
<?php echo($rsDetails->getColumnVal("Manufacturer")); ?><br />
<?php echo($rsDetails->getColumnVal("Model")); ?><br />
<?php echo($rsDetails->getColumnVal("BuildDate")); ?></p>
</body>
</html>