
November 1st, 1999, 11:49 AM
|
|
Guest
|
|
Posts: n/a
Time spent in forums:
Reputation Power:
|
|
|
Hi!
I was wondering if anyone might know the proper mysql syntax for a problem I am hitting.
I am playing around with setting up user authentication for a site using mysql as the backend and PHP up front. I don't want to create 50-1000 new records in the user and db tables for various and sundry reasons. I'd rather have a table (fooClients) within the site specific database (fooBase) already built.
Within fooClients there is an ID and a Login (read: password) field. While it would be very easy to have the Login as a varchar (15) field I'd prefer to use the password encyption. That's where the snag hits.
Select * From fooClient Where Login = 'foo'
doesn't work, because it's not passing 'foo' to mysql in it's encrypted form.
Select * From fooClient Where Login = password('foo') doesn't fly either.
Any ideas?
Mucho thanks in advance!
- Erik
|