So at the bottom of the page it will say:

Query Execution Time: xxxx ms.
anyone?

The question is a bit confusing- so a little background...

On my website I have a table of paper types whose data mostly consists of numerical indexes into several other tables. One field- for example- is color. When I do a query into the paper table- I can sort by the ID of the color- but the color names in the color table aren t in any order in reference to their IDs. What I really need is some way to sort the results of my query by the name of the color- not by the ID. Follow?

In other words- sorting by ID groups all papers with the same color together- but the order of the groups is haphazard. I want the result set to be alphabetized by color NAME- which is a field available in the color table. Can I do that?

Hi- I m getting started with PHP- and I read that I should download Apache- PHP- and MySQL. I know what MySQL and PHP are- but I need to know what Apache is/does. It said it s a web server- but I don t know what that means. Any info on this or anything else I need to know for programming in PHP is greatly appreciated. Thanks!

OK. On my site- I have a form. The user enters a word ($word. Let s use the example "You d") and it transfered to another page using the POST function. On that page- I do a mysql_escape_string on $word (Now I get You\\\ d). After that- it is put into a MySQL database (Where it is stored as You\ d). Follow me so far?

On another page- I retrieve that word. Now- when I try to do the SELECT function for MySQL- I say

"SELECT * FROM $table WHERE word= You\ d "

For some reason- it actually looks for "You\\\\\\\ d" and of course- it doesn t find it. Does anyone have ANY suggestions? I m in a pickle here. You get best answer for trying.

I am trying to run a site with Geocities- (because it s what I m familiar with/don t have a lot of money to start site)- and I am having a bit of trouble figuring out how to install Zen Cart.
I m not very proficient with FTP- either.

Here are the details:
I created the MySql and then I also made the catalog folder for the actualy Zen Cart stuff. But when I try to copy it into the FTP- it gives me a Critical Error for the .htaccess files.
Am I putting them in the wrong folder?
Should the catalog folder NOT be in the mysql folder?
Will they just simply not work with Geocities?
I have the small business account and the ftp is running smoothly- so I don t know what it could be.

Sorry if I seem ignorant to the subject- it s just a lot of stuff I don t know a lot about but would like to know more about. Any help would be greatly appreciated!

I am making a website and I just got to know something called MySQl. So- what is MySQL and what can it be used for??