if/else inside sql query?!

[jmansa]

How do I put and if/else statement inside an sql query?

if($hcpgroup == 0){
    ."WHERE cu.clubid = '$clubid' ".
} else {
    ."WHERE cu.clubid = '$clubid' AND u.h_index >= '$hcpgroup_start' AND u.h_index <= '$hcpgroup_end' ". 
}
."ORDER BY ecl.st_total ASC") or exit(mysql_error()); 

Can it be done?

Tnaks in advance...

[Waffles]

$query = "SELECT * FROM table";

if($hcpgroup == 0){

   $query.= " WHERE cu.clubid = '$clubid' ".

} else {

    $query.= " WHERE cu.clubid = '$clubid' AND u.h_index >= '$hcpgroup_start' AND u.h_index <= '$hcpgroup_end' ". 

}

$query.=" ORDER BY ecl.st_total ASC";

//$query= SELECT * FROM table WHERE cu.clubid = '$clubid' ORDER BY ecl.st_total ASC

$result=myql_query($query);
// etc 

should do it. essentially just concating parts of the query together.

[Jake Arkinstall]

Or, to cut things down a bit:

Or, even more:

$Query = "SELECT column, anothercolumn FROM table WHERE cu.clubid = '{$clubid}'";
if($hcpgroup != 0){
    $Query.= " AND u.h_index >= '{$hcpgroup_start}' AND u.h_index <= '{$hcpgroup_end}'";
}
$Query.=" ORDER BY ecl.st_total ASC"; 

$Query = SPrintF("SELECT column, anothercolumn FROM table WHERE cu.clubid = '%s' %s  ORDER BY ecl.st_total ASC", $clubid, ($hcpgroup > 0) ? "AND u.h_index >= '{$hcpgroup_start}' AND u.h_index <= '{$hcpgroup_end}'" : ''); 

[jmansa]

Or, to cut things down a bit:

Or, even more:

$Query = "SELECT column, anothercolumn FROM table WHERE cu.clubid = '{$clubid}'";
if($hcpgroup != 0){
    $Query.= " AND u.h_index >= '{$hcpgroup_start}' AND u.h_index <= '{$hcpgroup_end}'";
}
$Query.=" ORDER BY ecl.st_total ASC"; 

Thanks to both... Perfect solutions ;-)