# My SQL Database - What is it and how do I use it?

**URL:** <https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114>\
**Category:** flash\
**Created:** [May 26, 2002, 4:33pm UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114 "2002-05-26T16:33:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 26, 2002, 4:33pm UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/1 "2002-05-26T16:33:41Z")

</div>

And what for? I would appreciatte an in depth answer from anyone who has this knowledge. Thanks-

pj  
😛

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 26, 2002, 5:43pm UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/2 "2002-05-26T17:43:07Z")

</div>

a MySQL Database is a database for storing information in things called ‘Tables’ you can write to it, and retrieve info from it using PHP, CGI, and ASP (I think).

I know how to use it with PHP only though…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 26, 2002, 6:11pm UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/3 "2002-05-26T18:11:04Z")

</div>

Hey Fil, wanna mess with DB ?? 😃

Databases are used to store huge amount of information. To use them, you have to deal with objects that have similar properties. For instance, books in a library. You can give them different attributes, such as ‘title’, ‘author’, ‘numpages’, ‘releasedate’, ‘type’ and so on.

Once everything is registered, you can make queries on any attribute. For instance, if the user is looking for books that have more than 500 pages, you’ll have a query that looks like :

```auto
 SELECT * from MY_TABLE WHERE numpages>500 ;

```

This will give you all the books you wanted.

You can also make cross-tables queries, for instance if you want all the people who have read a book from Salman Rushdie. Whatever. And to be able to make those queries and display them afterwards, you need a language such as PHP or ASP.

pom 0]  
They’re also very practical to search your data.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 30, 2002, 5:32am UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/4 "2002-05-30T05:32:26Z")

</div>

I just finished packing my two mySql to Flash PHP scripts into a zip. When my site comes up tomarrow I’ll be able to mail these out… finaly. I’ll be sure you get them Phil.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 30, 2002, 10:46am UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/5 "2002-05-30T10:46:22Z")

</div>

Thanks Pom and Ups-

I appreciatte the light of knowledge, and asian chicks with petite builds as well. Doh!

pj  
😛

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 30, 2002, 11:44am UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/6 "2002-05-30T11:44:12Z")

</div>

Still waiting… I just finished a pretty good loadMovieNum(); example. Can’t upload anything yet… ARRRGGGGGG!!!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [May 30, 2002, 12:56pm UTC](https://forum.kirupa.com/t/my-sql-database-what-is-it-and-how-do-i-use-it/2114/7 "2002-05-30T12:56:20Z")

</div>

Hey Davey-  
Post your icon again–easier to go to your site hat way-

pj  
😛