Working with MySql database

[madcat]

Hi- Two quick questions. What are some programs available to use for working with MySql database tables - in order to avoid using the command line?

Also, can you store any type of information into an array? .txt files, .inc files, etc...Would any problems occur if the subscripts were too large?

Thanks-

[jatar_k]

for the first, phpmyadmin is a good one.

I don't totally understand the question. You want to load an array that contains the contents of files? Sounds like a bad way to go about things but maybe if you explain it a little more I will understand better.

[txbakers]

You can also tgry to find a copy of mySql-Front which is a very nice GUI front end to mySQL.

[lorax]

Also, can you store any type of information into an array? .txt files, .inc files, etc...Would any problems occur if the subscripts were too large?

Well, you can store a variety of data in arrays but I wouldn't use an array for these particular objects. Why would you want to?

[madcat]

I'm in school jatar_k learning about arrays at the moment. The way I see it, an array could be used to create a blog-like effect; where you see paragraphs which are basically just entries for the day. So you see the days date- then the paragraph and a horizontal rule before the next day.

It just seemed to me in class that you could supply this page via an array filled with your .txt files containing the days paragraph. Use the array_shift or unshift functions to add or subtract files.

This could be the most non-intuitive mis-guided method around for getting this done:) I'm just trying to see what else you can do with arrays so I see how they work. But, I don't see why you couldn't use .txt files in an array.

[lorax]

You could use the array to hold the filenames and then walk the array to select the file you want to load. That would make more sense to me.

[jatar_k]

that's exactly what I was thinking lorax.

No reason to store that much data in the array, if just the filename then you can access it at will anyway and the handling will be much faster.

[madcat]

I see, cool`~

Thanks for your help on these questions everyone.