Re: mysql_query > array
| From: | Erwin Kerk | Date: | Thu, 17 Apr 2003 10:19:53 +0000 |
| Subject: | Re: mysql_query > array | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27139@lists.php.net to get a copy of this message | ||
$recset = mysql_query("Your SQL Here");
$results = array();
if(num_rows($recset) > 0) {
while($results[]=mysql_fetch_assoc($recset)) {
//nothing to do here
}
}
$results now contains a 2 dimensional array
Erwin
shaun wrote:
any chance of a longer answer ;) "Matthew Nock" <matthew@mnc.com.au> wrote in message news:DOEEJNAFHHEJMCCGIDPDEELCEDAA.matthew@mnc.com.au...short answer: yes. -----Original Message----- From: shaun [mailto:shaun@mania.plus.com] Sent: Thursday, 17 April 2003 7:56 PM To: php-db@lists.php.net Subject: [PHP-DB] mysql_query > array Hi, is it possible to retreive the contents of a query to an array. The reasoniask is because i have a page which shows a list of sytems held in the Systems table. By each system i have a check box and if the user is competent in that system i want to place a tick in it. This data is stored in User_Systems with System_ID and User_ID. So what i would like to do is query the Systems table to get all the systems then query the User_Systems table and get an array of system_ids. Then whilst drawing the table of checkboxes i can check to see if the system_id for that checkbox is in the array... Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php