Syntax Error Data Bridge 234

Hello Ray
I have updated some pages for DataBridge 234 but am getting some syntax errors
the error message is
Parse error: syntax error, unexpected '&&' (T_BOOLEAN_AND) in
C:\xampp\htdocs\boatsforsalenow_mysqli\BoatResults.php on line 6
Would you please have a look at the files attached to see where I am going wrong?
Thanks
John

Line 6 has:

if (isset($_POST["WADbSearch1"])) && ($_POST["WADbSearch1"]) {

it should be:

if (isset($_POST["WADbSearch1"]) && ($_POST["WADbSearch1"])) {

Thanks Ray
That cured line 6
On Line 77 this appears $queryString_*** No Recordset Found = "";
This also applies to 88, 91, 201,

That section of code isn't used in MySQLi... you can delete lines 59-92.

On lines 191-201, that appears to be leftover code from mySQL. The MySQLi version is different. I'd just delete the <a> tag around the text and re-apply the server behaviors to add the navigation back.

Hello Ray
I carried out those changes but ran into some more errors.

On the local machine I am getting some errors (images attached) showing,
but the same pages look different on the remote server.

Many thanks
John

It looks like the MySQLi conversion didn't update all of the references to MySQLi on the page.

Every time you have: <?php echo $row_rsSearch['YourColumnName']; ?>
It should be: <?php echo $rsSearch->getColumnVal('YourColumnName'); ?>

Usually that update is done automatically when you update the recordset, so I'm not sure why it didn't work properly this time.

It also didn't update the first row, last row, total rows text and didn't remove the free_result() reference on the page. These can be updated manually at this point by re-adding them from the MySQLi server behaviors and removing the old code. You can also delete lines 19-53.

You can make those changes manually at this point, or if you have the original version of this page and update the recordset all of these should be updated automatically as well.