Re: selection from multiple tables;

2001-08-25 Thread Charles Williams
- Original Message - From: "muruganandam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 05, 2001 4:04 PM Subject: selection from multiple tables; > > for a particular query i have to select data from five tables. > can any one suggest me a best way to do that in

Re: Data Encryption

2001-08-23 Thread Charles Williams
is actually held > in mysql in an encrypted form? Then it can speed up and down the phone > lines in the 'raw' so to speak, but it's still in code so no one can get it > anyway? > > We wouldn't need SSH or SSL then would we? > > Or is that too simplistic? >

Re: Data Encryption

2001-08-22 Thread Charles Williams
I use a random key generating SHA-1 js module for all my encryption for passwords. You could do something the same using a fixed key system so that once it's on the server you can decrypt it. However, I haven't tried it yet with SHA-1 so don't know how difficult or sane it would be to try. chuc

Retrieving Auto-increment index after insertion.

2001-08-16 Thread Charles Williams
Hello, I am trying to figure out how I can retrieve an automatically incremented index after I insert data into the table. The index is the ONLY information that is unique in the entry at times and additions are quite often. Any ideas would be appreciated. Thanks, chuck Chuck's Top 10 Things

MySQL Multi-Table Select Query Problem

2001-08-15 Thread Charles Williams
Hey folks, I'm new to the list and already have a problem. if you go to http://www.acnsnet.com/czc/show.php?state=Bayern You can see my problem with this query. This thing is killin me so if you have any ideas just shout. thanks, chuck Chuck's Top 10 Things to Remember and Think about! =