Database SELECT Query Class

Use the database class new_select_query method to create an object of the db_select_query class. This query class implements the creation of a SELECT SQL statement.

add_where($where)

The $where parameter is an array with the following elements:

• 0 - Name of the field
• 1 - Condition, for example: '=', '<>'
• 2 - Field type: DSCORE_DB_INTEGER_FIELD, DSCORE_DB_STRING_FIELD
• 3 - The value to check for

The example below demonstrates how to add a where clause that checks if the 'user_name' field equals the string held in the $username variable.

$query->add_where(array('user_name', '=', DSCORE_DB_STRING_FIELD, $username));