Introduction - Query

Introduction - Query – Performing a query against a database.

Description

To perform a query against a database, you have to use the function query(), that takes the query string as an argument. On failure you get a MDB_Error object. Be sure to check it with MDB::isError(). On success, you get MDB_OK or when you set a SELECT-statement a result resource handle

A simple MDB query

<?php
// Once you have a valid MDB object...
$sql "select * from clients";

$result $db->query($sql);

// Always check that $result is not an error
if (MDB::isError($result)) {
    die (
$result->getMessage());
}

// Continue on with your script
?>