PHP getTableSelected Examples

Example #1

File: provas.php Project: ricain59/fortaff

function provaCountBilhete($tipoBilhete)
{
    if ($tipoBilhete == "C") {
        $fields = "lugares_vendidos";
    } else {
        if ($tipoBilhete == "R") {
            $fields = "lugares_reservados";
        } else {
            $fields = "lugares_vendidos + lugares_reservados";
        }
    }
    $e = getTableSelected("provas_total", array("SUM(" . $fields . ") AS total"), "status <> 'X'", "");
    $row = forEachRow($e);
    return $row['total'];
}

Example #2

File: mysql.php Project: ricain59/fortaff

function getTable($table, $where, $orderBy)
{
    return getTableSelected($table, array('*'), $where, $orderBy);
}