MySQL Question

BYOND Forums

Announcements · BYOND Help · Bug Reports · Feature Requests · Beta Testers · Beta Bugs · Developer Help · Design Philosophy · Demos & Libraries · Tutorials & Snippets · Art & Sound · Classified Ads · Game Updates · Contests & Events · Linux Talk · On Topic · Off Topic

MySQL Question

ID:21793

Oct 29 2006, 7:01 pm

Keywords: idiot, php, sql, website

Danial.Beta

I am currently the web master for http://GoneGreek.com and I have run into a little issue. I am really wanting to move to a database because of the number of items and the pain of trying to manage them all.

The only problem is that some items have lists of drop box options of over 50 items. I was wondering if any of you knew the most efficient way to lists of these kind with php/mysql. I don't mind manually editing the database(Using MyPHPAdmin), but I just don't see an easy way to do these lists.

The best I could think of was to have a table just for the options, but that seems like a bad way to do it.

I know we have a few people with a lot of experience with MySQL, so if any of you could chime in, I would be very thankful.

Oct 29 2006, 9:27 pm (Edited on Oct 29 2006, 9:32 pm)
Tiberath	Can you rephrase the question. I have alot of MySQL and PHP Experiance. But I don't understand what you mean. The only thing I got was "move database" It'd be easier to discuss something like this in real time. If you have MSN: ambient546[at]hotmail[dot]com or I'm online in My BYOND Membership Giveaway game. byond://202.76.166.212:6115

Oct 29 2006, 9:34 pm
Danial.Beta	http://www.gonegreek.com/index.php?page=shirts-jerseyfs Using that for example: We can see 2 drop boxes with 20+ items in them. I am looking for a way to use a MySQL database while maintaining those drop boxes. Most items keep that same list. I want an easy way to put that list into the database and have it linked with items.