Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by RRoswell
-
Move Recs from/to Identical Tables
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... -
Move Recs from/to Identical Tables
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... -
Table Setup Question - Index v. Unique
I really appreciate your help. Thank you! -
Table Setup Question - Index v. Unique
"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... -
Table Setup Question - Index v. Unique
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... -
Table Setup Question - Index v. Unique
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... -
SELECT from Two Tables
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... -
-
SELECT from Two Tables
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... -
Global Test Directory
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...- RRoswell
- Post #3
- Forum: Linux (server)
-
How Do I Install Programs?
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...- RRoswell
- Post #10
- Forum: Linux (server)
-
How Do I Install Programs?
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.- RRoswell
- Post #8
- Forum: Linux (server)
-
How Do I Install Programs?
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.- RRoswell
- Post #5
- Forum: Linux (server)
-
How Do I Install Programs?
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...- RRoswell
- Thread
- Replies: 9
- Forum: Linux (server)
-
