Query Builder open

I am using the MySQLi Recordset tool and when I click on "Query Builder" nothing the WEBASSIST window disappears. On the other hand, if I click on "Simple" everything works fine. Also, if I "test", it works fine and shows results. Just if I click on the "Query Builder" the window disappears and nothing happens. Two days ago it was working fine.

To try to resolve, I uninstalled the "MySQLi Server Behaviors" extension. I then re-installed it into Dreamweaver. Installed correctly, but still have same issue.

Not sure what to do to fix. Can anyone please help?

Thank you very much for your help.

I don't think I've ever used the Query Builder button. Usually to create a Recordset I just go to the Bindings panel, click the Plus icon and choose either Recordset (Query) or MySQLI Recordset (Query) (both work the same as long as the connection you choose is a MySQLi connection). Then in the Database items list I choose the table & column I need from the dropdowns and click the Select button, then repeat for each column you need to include. Then use the Where and Order By buttons in the same way. You can also add variables in the same window. If you need a more complex query such as joining tables, I usually find it easier to code this by hand by adding in the necessary joins after the recordset info has been added and then testing it in something like HeidiSQL.

You could also try clearing the Dreamweaver cache by deleting the cache file (on Windows located at C:\Users\[username]\AppData\Roaming\Adobe\Dreamweaver CC 2019\en_US\Configuration\WinFileCache-[randomString]. dat) - close Dreamweaver, delete file, restart Dreamweaver.

Thanks for reply its solved
I have a question for you. have you ever create menu editor like wordpress? I am attaching demo

I'm not a big user of Wordpress but yes, I've created menus using the menu editor.

I was asking have you created menu editor with PHP MySQLi?

No, but you could achieve it using DataAssist pages I'm sure.