Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Multiple MySQLi Connections

Multiple MySQLi Connections

Thread begun 2/15/2019 8:22 am by Dave Buchholz | Last modified 2/15/2019 8:47 am by Ray Borduin | 912 views | 6 replies |

2/15/2019 8:22 am | #1 Dave BuchholzBeta Tester

Multiple MySQLi Connections

I am having an issue where I need to connect to 2 different databases in a single page, the connections are set up in Dreamweaver and I can see the databases and the tables just fine when I view them using the DataBase window (see screenshot) but when I add the 2nd recordset using the extra connection the page dies with this error:
Fatal error: Call to undefined function getColumnVal() in /Users/***/Sites/***_new/wwwroot/_site-files/pages/product-pages/product-details-page.php on line 47

I suspect not many people try to do this so it might not have been flagged before.

2/15/2019 8:24 am | #2 Ray BorduinWebAssist

Please attach the full page: product-details-page.php

I'll take a look to see what might be wrong. I may need FTP access and a URL to fully debug this.

Did this help? Tips are appreciated...

2/15/2019 8:36 am | #3 Dave BuchholzBeta Tester

Attached, this page is pulled in by Framework Builder and all the connections etc. are handled in a separate application file

2/15/2019 8:39 am | #4 Ray BorduinWebAssist

On line 47 you have:
$rsAdditionalImages>getColumnVal("large")

it should be:
$rsAdditionalImages->getColumnVal("large")

Did this help? Tips are appreciated...

2/15/2019 8:41 am | #5 Dave BuchholzBeta Tester

I don't see any difference between the 2 pieces of code ?

2/15/2019 8:42 am | #6 Ray BorduinWebAssist

One has ">" and the other has "->"

Did this help? Tips are appreciated...

2/15/2019 8:43 am | #7 Dave BuchholzBeta Tester

I am an idiot, the perils of copying and pasting, thanks Ray

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.