Re: MySQL Wildcard
| From: | Onur Yerlikaya | Date: | Fri, 07 May 2010 09:16:14 +0000 |
| Subject: | Re: MySQL Wildcard | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47145@lists.php.net to get a copy of this message | ||
function getOptGrps($ID=null){
if ($ID == "All") {
$ID = "%"; // % = MySQL multi character wildcard
}
$extraClause = "";
if(!is_null($ID))
{
$extraClause = " WHERE OptGrpID LIKE '$ID' ";
}
$q = "SELECT * FROM ".OPT_GRPS_TABLE.$extraClause;
$result = $this->query($q);
/* Error occurred, return given name by default */
if(!$result || (mysql_numrows($result) < 1)){
return NULL;
}
/* Return result array */
$array_results = mysql_fetch_array($result);
return $array_results;
}
On May 7, 2010, at 11:46 AM, Karl DeSaulniers wrote:
> ...
--
Onur Yerlikaya