so sorry
function getOptGrps($ID=null){
$extraClause = "";
if($ID != "All")
{
$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 12:36 PM, Karl DeSaulniers wrote:
>
> 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Onur Yerlikaya
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
