Help with converting to mySQLi

I started looking at this a while ago, but am just coming back to it now. I was having some issues with recordset not being visible in the Server Behaviours panel. I am just looking at a pretty standard page with just a couple of recordset, and no inset or update. But the main recordset is not visible to change. I have looked at it and removed things like line breaks, but still no luck. I have a lot of pages to update, so would be good if you can have a look at this one and advise of other things I can be looking for that is causing this. I have attached the page here. Thank again.

Dreamweaver is pretty picky... you just need a line break between these lines (line73).

$row_WADAlodges = mysql_fetch_assoc($WADAlodges);

if (isset($_GET['totalRows_WADAlodges'])) {

Then the recordset will appear.

Thanks Ray - can see it now. DW is just hanging though - has been for about 15 minutes. I'm running DW 20.2. DW19 currently crashes on me when I get past the welcome thing, and its hanging in DW 18. Running macOS 10.15.5, and the current version of DB 2.3.5. There probably isn't anything you can do to fix that though...

Attach the file I can probably spot it. Usually it is something small like a missing or extra line break or space or something that is preventing the Server Behavior from loading properly and then it hangs.

If you send the page that hangs I can try to figure it out for you.

Thanks Ray. One thing - might it be because the page has an include? Basically these ones are like saved search results per country, and use an include file that is shared for each country page.

The page opens without hanging for me. That means it might be the contents of one of the includes causing the problem. You could try opening them individually to see which one is the culprit and send me that file to look into it.

That might have been crossed wires there - the page opens OK, but hangs when I try to change the connection file for the recordset from the mySQL one (connSafari.php) to the mySQLi one (connSafari_wa_i.php). You might need to be connected via FTP to see if you have the same thing happen. Its currently

It was an issue associated with having server behaviors related to the recordset in include files. I updated the DataBridge extension to skip server behaviors from includes when upgrading to make sure it doesn't happen moving forward. Please reinstall databridge to resolve this issue.

In my testing I updated the page and include files related to it to MySQLi. You can download the updated pages from your site.

Thanks Ray. I was just looking at an unrelated thing, and something weird seems to have happened to the site (i was only looking at the site in a browser, not changing any files or anything).

But when I log on now, I am just seeing the logo at the top, and blank pages apart from that.

Was it just that one page you changed? I'll download it here and save it as something else, and see if rey-loading the copy I have here fixes that.

This is because I converted the include files to MySQLi and they now require the pages they are included on to have the correct MySQLi recordsets to reference them.

You will have to update the pages to mySQLi or go back to the mySQL version of the include files.