MySQL Wildcard
in [Databases]
|
Prev: Updating MySQL Database after install
Next: PDO + The Role of PHP + SQLite - Am I missing something?
From: Karl DeSaulniers on 7 May 2010 04:46 Hello All, What I want to do is get all the fields from a table without specifying which ID to grab from. I am trying to implement a wildcard in my query. What am I doing wrong? I keep getting... "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" CODE::::: function getOptGrps($ID){ if ($ID == "All") { $ID = "%"; // % = MySQL multi character wildcard } $q = "SELECT * FROM ".OPT_GRPS_TABLE." WHERE OptGrpID LIKE '$ID' "; $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; } AND this does not work either function getOptGrps(){ $q = "SELECT * FROM ".OPT_GRPS_TABLE; $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; } TIA, Karl DeSaulniers Design Drumm http://designdrumm.com
From: Onur Yerlikaya on 7 May 2010 05:16 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
From: Karl DeSaulniers on 7 May 2010 05:36 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
From: Onur Yerlikaya on 7 May 2010 05:40 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
From: David Robley on 8 May 2010 00:59
Karl DeSaulniers wrote: > Hello All, > What I want to do is get all the fields from a table without > specifying which ID to grab from. > I am trying to implement a wildcard in my query. What am I doing > wrong? I keep getting... > > "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL > result resource" > > CODE::::: > > function getOptGrps($ID){ > if ($ID == "All") { > $ID = "%"; // % = MySQL multi character wildcard > } > $q = "SELECT * FROM ".OPT_GRPS_TABLE." WHERE OptGrpID LIKE > '$ID' "; > $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; > } > > AND this does not work either > > function getOptGrps(){ > $q = "SELECT * FROM ".OPT_GRPS_TABLE; > $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; > } > > TIA, Well, I'd hazard a guess that OPT_GRPS_TABLE may not be what you think it is; in any case, the first step in debugging would be to echo your query $q and see what it really contains. And does the class that handles your db query have an error reporting function? If so, try using it. Note that to retrieve all records, you could skip the WHERE, or use WHERE 1 Cheers -- David Robley Machine-independent: does not run on any existing machine. Today is Pungenday, the 55th day of Discord in the YOLD 3176. |