Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Dlookup equivalent in php

Dlookup equivalent in php

Thread began 3/07/2022 7:12 am by birdscreen398247 | Last modified 3/08/2022 12:00 pm by birdscreen398247 | 204 views | 5 replies

3/08/2022 11:20 ambirdscreen398247

DLookup finds a single piece of data without having to create a recordset, etc.

For instance:

MVariable = DlookUP("Field you are looking for", "Table", "Criteria")

So you can retrieve this data with a single line of code.

It is a VERY handy function.

In PHP/SQL, it takes 5 lines of code (basically creating a query targeted on one field in one record)

I was just trying to see if there was a similar structure in PHP that did the same thing in one line.

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.