Re: [PHP-DB] Filter array results... no copies

2007-01-11 Thread Chris
Chris wrote: Matthew Ferry wrote: Hello everyone I'm back working on the website again... I'm having lots of fun. I have a sql query that looks at one field in a database. (result2 query) Then i have mysql_fetch_array statement. For future reference, if you only have a problem with one pa

Re: [PHP-DB] Filter array results... no copies

2007-01-11 Thread Chris
Matthew Ferry wrote: Hello everyone I'm back working on the website again... I'm having lots of fun. I have a sql query that looks at one field in a database. (result2 query) Then i have mysql_fetch_array statement. For future reference, if you only have a problem with one particular part

Re: [PHP-DB] Filter array results... no copies

2007-01-11 Thread tg-php
If all you want is a unique list of "adr_one_region" codes, then use the DISTINCT keyword in your SQL: SELECT DISTINCT adr_one_region FROM egw_addressbook WHERE cat_id='8' ORDER BY adr_one_region -TG = = = Original message = = = Hello everyone I'm back working on the website again... I'

[PHP-DB] Filter array results... no copies

2007-01-11 Thread Matthew Ferry
Hello everyone I'm back working on the website again... I'm having lots of fun. I have a sql query that looks at one field in a database. (result2 query) Then i have mysql_fetch_array statement. I then use this array to print links on the page. Works fine except I don't want duplicate links.