Re: [PHP-DB] MySQL Wildcard

On May 7, 2010, at 4:16 AM, Onur Yerlikaya wrote:

> 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

Thanks Onur, but same error message.
It is not setting the % as a wild card.
Not sure the way around this.


Karl

>
>
>
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com