Re: Newbie question - is this possible

There's a nice article on sitepoint.com by Kevin Yank called something like "restricting page access with php and mysql"... should give you a boost in the right direction. Simply though, the user info table has to relate to the users table. table users: uid (eg "justin") pass (encrypted, eg "alskjgfakgiu32tgqnva") table userinfo: uid (eg "justin") first last email whatever whatever Table users could be used to check/validate login, and table userinfo could be used to get infomation about the user... although at THIS STAGE, they look like all that information could be in one table. Justin on 15/09/02 4:13 AM, Ray Healy (Data Net Services) (ray@matrix-datanet.co.uk) wrote: > Dear All > > Could someone advise whether this is possible to do using PHP & mySQL and if > so could they point me in the right direction or web site. > > What I want to do is to set up a user/password database and then another > database with the users information in it (have not decided what rows to have > - say name , address, picked numbers, wins, losses). > > When a user comes to my site a login box will appear where they type there > username & password. This is checked with the 1st database and if OK there > details are displayed by getting them from the 2nd database. > > This way the user can only ever see their own data and no one else's. > > I can probably work out how to set the login check but cannot plan in my head > how to then display that users details from the other database. > > I hope this makes sense. I have posted this in both groups as it is database > related as well. > > Any comments much appreciated. > > Thanks > > Ray >