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
