Thank you for the correction. I have made the changes and started again.
Master:
<?php require_once('Connections/mitoWebsiteMSQLI.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$master2Recordset1 = new WA_MySQLi_RS("master2Recordset1",$mitoWebsiteMSQLI,10);
$master2Recordset1->setQuery("SELECT * FROM completedProjects ORDER BY project_name ASC");
$master2Recordset1->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<ul>
<?php
while(!$master2Recordset1->atEnd()) {
?>
<li><a href="details2.php?mission_id=<?php echo($master2Recordset1->getColumnVal("mission_id")); ?>"><?php echo($master2Recordset1->getColumnVal("project_name")); ?></a></li>
<?php
$master2Recordset1->moveNext();
}
$master2Recordset1->moveFirst(); //return RS to first record
?>
</ul>
</body>
</html>
Details:
<?php require_once('Connections/mitoWebsiteMSQLI.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$details2Recordset1 = new WA_MySQLi_RS("details2Recordset1",$mitoWebsiteMSQLI,1);
$details2Recordset1->setQuery("SELECT * FROM completedProjects");
$details2Recordset1->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<ul>
<li><?php echo($details2Recordset1->getColumnVal("client_name")); ?></li>
<li><?php echo($details2Recordset1->getColumnVal("project_name")); ?></li>
</ul>
</body>
</html>
The details data is showing for the first record only. When I click on the link from the masters page it will take me to the details page and list the first project, no matter what link I click on the masters list.