On Sunday 25 May 2003 22:49, Frank Keessen wrote: > If got in one field multiple values (example; 5,6 or 7,9,23). > > The seperator is a comma. > > Question is: how can I retrieve this fields out of mysql and put it in > array?? How are you using this field? It isn't a very efficient nor usable way of storing things. Trying to perform queries using this field doesn't seem that practical. If the values that the field can contain are limited then you should consider changing it to type SET. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* How sharper than a serpent's tooth is a sister's "See?" -- Linus Van Pelt */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php