This select method sucks... suggestions?
Posted: Thu Nov 10, 2005 4:57 pm
I made this select method to go with my database interaction class... but it isn't very flexible. What could I do to make it more flexible?
Code: Select all
function Select($searchword, $searchfield, $returnfields, $table, $relevance='=', $limit=1, $order=''){
$sql = "SELECT ";
if(is_array($inputfields)){
foreach($returnfields as $val){
$sql .= "`" . $val . "`,";
}
$sql = substr($sql, 0, -1);
}
else{
$sql .= $returnfields;
}
$sql .= " FROM `" . $table . "` WHERE `" . $searchfield . "` " . $relevance . " '" . $searchword . "'";
if(!empty($order)){
$sql .= " ORDER BY `" . $order . "`";
}
$sql .= " LIMIT " . $limit;
if($results = mysql_query($sql)){
while($row = mysql_fetch_assoc($results)){
$return[] = $row;
}
return $return;
}
logerror("Could not execute query: " . $sql . "\n MySQL says: " . mysql_error());
return false;
}