Re: Query table / results to an array
| From: | Chris | Date: | Fri, 29 Feb 2008 05:56:55 +0000 |
| Subject: | Re: Query table / results to an array | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44694@lists.php.net to get a copy of this message | ||
Ron Piggott wrote:
This line of code while ($row = mysql_fetch_assoc($result)) { Gave me this error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource I ran select reference, description from table in mySQL and it worked --- Any idea what caused the error?Oops.. $result = mysql_query("select id, description from table");
On Fri, 2008-02-29 at 16:39 +1100, Chris wrote:-- Postgresql & php tutorials http://www.designmagick.com/Ron Piggott wrote:I need help populating an array based on the output of a mysql query. $reference_number is a value assigned by auto_increment $description is what I want the value of the array to be --- a few words in length $reference_number = mysql_result($search_result,$i,"reference_number"); $description = mysql_result($search_result,$i,"description");$references = array(); $result = "select id, description from table"; while ($row = mysql_fetch_assoc($result)) { $references[$row['id']] = htmlentities($row['description'], ENT_QUOTES, 'ISO-8859-1'); } print_r($references);