Getting all entres in SQL table and putting in array? Getting Should be easy

[CrewXp]

Hey, this should be simple, but I just need a quick basic foundation to start out on, then i can usually figure it out from there.

I just got mysql.au3 working, but now...

I have a table named 'categories' that has a list of other tables, with each entry having 'visible' and 'name' fields.

How do I get all entries in my table 'categories', and save them to an array?

Example:

TABLE categories:

name:Projects,visible=1

name:Videos,visible=0

name:Sounds,visible=1

name:Utilities,visible=1

I want Projects,Sounds, and Utilies to be stored in an array.

ps: Can I also do a 'where'? Like

"Get contents of table: 'category', but only the items where 'visible'=1 for it"

Edited August 24, 2007 by CrewXp

[PsaltyDS]

Hey, this should be simple, but I just need a quick basic foundation to start out on, then i can usually figure it out from there.

I just got mysql.au3 working, but now...

I have a table named 'categories' that has a list of other tables, with each entry having 'visible' and 'name' fields.

How do I get all entries in my table 'categories', and save them to an array?

Example:

TABLE categories:

I want Projects,Sounds, and Utilies to be stored in an array.

ps: Can I also do a 'where'? Like

"Get contents of table: 'category', but only the items where 'visible'=1 for it"

The SQL98 (the standard SQL syntax for all DBs) query would be:

"SELECT Projects,Sounds,Utilities FROM category WHERE visible = 1"