CodeCharge Studio

CCDLookUp Function (PHP)

Description

Retrieves a single database value which can be a field or an expression. The arguments passed to the function determine the value to be retrieved. Execution of this function causes any previously retrieved records in the connection object to be overwritten with the new recordset.

Syntax

CCDLookUp(field, table, where_clause, connection)

Return value

string

Parameters

Name Type Description Required
field string Name of the database table field to be retrieved or an SQL expression whose value is to be retrieved. Yes
table string The name of the table from which the value is to be retrieved (SQL JOIN directives are possible). Yes
where_clause string SQL WHERE clause: the part of the SQL query that states the criteria for selecting the value. Yes
connection cls object Connection object against which the query will be executed. Yes


On-line, printable versions and updates