anti — Thu, 19 Aug 1999 02:06:00 +0000

Right now im in Hursley (near Southampton) In England.

ciao
Anti
ps:
I don't know if that are 2000km, but it's close (far ??) enough.

JP Stones — Tue, 17 Aug 1999 19:45:00 +0000

Where are you staying again Anti?
JP

----------
The Webmaster Promotion and Resource Center.
Visit: http://www.what-next.com

anti — Tue, 17 Aug 1999 04:02:00 +0000

Hi dass,

sorry, I'm under very heavy pressure right now.

In the doc for mysql are some small perl samples.
They are almost perfect for you.

The select in my first answer does exactly what you want.

select member from members where member='$login';

And just check how many results you get.

btw:
your TABLE contains three columns. and your DATABASE contains that TABLE.

I could write a small example, but my test-system is 2000km away and I have almost no time. maybe when I'll get back (10/99) ... sorry

ciao
Anti

Dass — Sat, 07 Aug 1999 02:09:00 +0000

anti, was that description good enough, or do you needa little more ifno on what I'm talking about to help me?

----------
[Dass]
[Email:robp@netlimit.com]-[ICQ:16560402]-[Voice Mail:1-877-309-2286]

Dass — Thu, 29 Jul 1999 20:48:00 +0000

Note not taken personally anti

OK
The database contains 3 columns with the names "member", "password" and "email"

Now for creating new accounts, I will need to check the "member" column to see if the member name already exists. How do I specifically choose the "member" column to see if $login==$member.

I have heard alot of bad things about dummies books, have you read sql for dummies?

----------
[Dass]
[Email:robp@netlimit.com]-[ICQ:16560402]

anti — Wed, 28 Jul 1999 20:55:00 +0000

Hi Dass,

could you please describe your DB-setup more exactly ?
You have a Database.
Your have a Members Table.
The Members Table contains to columns ?!
What are the names of those Columns ?

Sql for Dummies costs 20 bucks at barnes&noble.
You pay more for your host each month.

ciao
Anti
ps:
please don't take it personal, but you usually get much better answers if you are more specific about your questions and give more details.

Dass — Wed, 28 Jul 1999 01:01:00 +0000

What I will want it to search the members column (2 columns in database) and check if $login is equal to any of them.

For the book, would I buy a mysql specific book, or just sql? (these stupid computer books cost alot of money that I don't have err ;( )

----------
[Dass]
[Email:robp@netlimit.com]-[ICQ:16560402]

anti — Tue, 27 Jul 1999 21:18:00 +0000

Hi,

select login from users where login='dass';

or what do you want ?
Grab "SQL for Dumies" or "SQL in 21 days" and your life will be much easier.

ciao
Anti