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

Mysql statement as variable (if – else)

23rd October 2014

MySql

mysql codehaven category

if ($showmonth == "on") {
$dog = "SELECT name FROM targets WHERE name ='codehaven'";
}
else {
$dog = "SELECT name FROM targets WHERE name ='mike'";
}

//the query ($dog is in it!)

$result = mysql_query($dog);

while($row = mysql_fetch_array($result))
{
$whatever = $row['whatever'];
}