Get values for just one column from a broader MySQL query?
Posted: Fri Jun 16, 2006 10:18 pm
Hello,
Sorry, I can't come up with a good subject for this question. My PHP-driven website uses a MySQL query that goes something like this:
I have a column in this table called 'area' which contains the key values for another table. What I want to do is throw all values of 'area' that result from the above query (duplicates excluded) into an array. I feel like I should be able to do this without making another call to the database, but I can't figure it out.
Any and all help appreciated.
Thanks!
Sorry, I can't come up with a good subject for this question. My PHP-driven website uses a MySQL query that goes something like this:
Code: Select all
SELECT *
FROM table
WHERE type LIKE '%G%'
AND [a bunch of other stuff]Any and all help appreciated.
Thanks!