Dynamic zone query

[Akkadius]

Originally Posted by Maceblade

Im sorry for the newb question, but im trying to figure out how to open up more than 5 dynamic zones. IDK how to show a list of variable or tables inside mysql bc im very new at this stuff... I was curious if anyone knew of the exact command to punch in or the 'xxxxxxxxx'; portion of it. Thanks

mysql> describe launcher;
+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| name     | varchar(64)         | NO   | PRI |         |       |
| dynamics | tinyint(3) unsigned | NO   |     | 0       |       |
+----------+---------------------+------+-----+---------+-------+
2 rows in set

mysql> select * from launcher;
+------+----------+
| name | dynamics |
+------+----------+
| zone |        5 |
+------+----------+
1 row in set

That is where you set your dynamics.

[Maceblade]

ah very nice now I can see the variables... now with some research I will soon be able to find out how to change it lol... Thanks alot Akk

[jdoran]

Writing SQL is needed for changing values from within code. But for stuff like this, the easiest way is to use some sort of SQL front-end, like Navicat.