Re: mysql_query > array

Erwin Kerk <erwin@scoutingnederland.nl> · Thu, 17 Apr 2003 12:19:53 +0200

$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
DOEEJNAFHHEJMCCGIDPDEELCEDAA.matthew@mnc.com.au">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:  mysql_query > array

Hi,

is it possible to retreive the contents of a query to an array. The reason

i

ask 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

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