codehaven - php snippets - coding help
[wd_asp elements=’search’ ratio=’100%’ id=1]
octopus energy discount code

Build a mysql statement dynamically

17th June 2013

MySql

mysql codehaven category


if ($clientselect) {
$sql[] = " client = '$clientselect' ";
}

$query = "SELECT * FROM cmdata WHERE time=$thishour AND date='$thisday' AND cpa = '0.00'";

if (!empty($sql)) {
$query .= ' AND ' . implode(' AND ', $sql);
}

echo $query;
$result2 = mysql_query($query);