Search results for query: *

say, how come you have 2 tables anyway? i would use just one table and an active/inactive flag" I may do that. I'm setting up a cron job and I wanted its processing time to be as minimalist as possible. What I really want to do is check for new customers, and if they exist, process the order...

Hi, Seems like I saw a way to do this down and dirty, but I can't find the answer and I might be wrong. I have two customer tables, one for active customers, and one for past customers. They are identical, but they have many columns, and I was wondering if there was an easy way to move...

I really appreciate your help. Thank you!

"you can optimize that query by ensuring that dom is indexed in both tables" 'dom' is unique in both tables - changing that to index would be better? I guess I'm not understanding PK's very well - I didn't think it was wise to make a string a key value. In places where I used to work, we...

That helped a lot right there. This is one of the main queries: $query = "SELECT dom FROM domains WHERE dom = '$n' UNION SELECT dom FROM cart WHERE dom = '$n'"; Basically what I'm trying to check for is an existing domain or a domain in the process of being purchased. 'dom' is unique in both...

Hi, I've got one main table with nothing but a numeric, primary key and a varchar column that will contain unique domain names (never a duplicate). The primary key auto_increments and the varchar column is "unique" for now. Is that pretty much the most optimized setup, or should I make the...

r937, That was some star-worthy advice. Each item is unique, so it should only appear in the cart while the user is buying the product, or in the account table after it has been confirmed that they paid for the item. I can see some items slipping through the cracks and getting stuck in the...

Are you spoken for? :) Thanks a million!

Hi, I have two tables, a cart table and an account table. I need to see if an item is in either table with one Select statement. The item should never be in both tables at the same time. I try this but it's not working: SELECT a.item, c.item FROM accounts a, cart c WHERE a.acct = '$item' OR...

I appreciate your help. I don't know what I'm doing wrong. When I do this, it causes an error that keeps the server from starting: ##########VIRTUAL HOST SETUP########## # TEST <VirtualHost *> DocumentRoot "X:\testserver" ServerName tst </VirtualHost> <Directory "tst"> Allowoveride...

Thanks Ace, I'm running CentOS 4.5 and so far the original version of FireFox because I still can't figure out how to install things. I tried it the way that you described, too. It says it's installed, but it FireFox doesn't see the plugin. Found some pretty good documentation (finally) and...

The CentOS forum hasn't been very helpful yet. I tried to install the Flash player. It says it's installed, but FireFox won't see any Flash content. This is going to take a while... Thanks for all the help.

Tanks for your help. I installed CentOS 4.5, and I think it included the Yum service upon installation, but I can't find the repository. Is it a folder? What I'd like to do, first off, is install the Flash plugin for Firefox.

I'm having a devil of a time with this. I'd like to find a step-by-step instruction on how to install programs on CentOS. I don't know how to navigate in the shell. Don't know how to get the shell to the folder with the program. I think I type "yum install (program)" but I don't know how...

Thanks for your input.

Hi, I'm thinking about buying a new desktop, and I've heard that the liquid-cooled kind were more quiet than the air-fan alternative. Is that true? I'd really appreciate some pointers on where to buy a quiet desktop PC. Thanks.

pan - Thanks so much - I'll give it a try.

Pan, This is the message in FireFox: You have attempted to establish a connection with “www.mysite.com”. However, the security certificate presented belongs to “sls-ad888-srv2.myhost.net” (my host). It is possible, though unlikely, that someone may be trying to intercept you communication...

Thanks Pan, It's a Linux/Apache box that I just bought and somebody else is hosting. I'm just bone-headed when it comes to this stuff and I don't seem to be getting through to anybody. I kind of think that my problem is so simple that people aren't understanding the problem. I have a webmail...

Thank you, Pansophic. I know there's a way around this, because I know that there are thousands of boxes hosting multiple domains and I rarely if ever see that alert about the certificate. To me, it's a very bad sign and one I don't want my customers to ever see. I'm having a really tough...