Sign in to follow this  
Followers 0
CrewXp

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

2 posts in this topic

#1 ·  Posted (edited)

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 by CrewXp

Share this post


Link to post
Share on other sites

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"

:)


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0