first of all you should specify a the second table "lidmaatschap" in your "FROM" statement (doesn't work for me if i don't)
then you should look into $sth->fetchrow_hashref then look into quoting&placeholders (especially when dealing with stuff like passwords) then try this: depending on whether the user logged on successfully or not, let your script throw out a redirect-header: print "location: http://whereever.you.want\n\n";; (where the URL can be $ENV{HTTP_REFERER} , but noone said that there must be anything in that scalar) on the other hand, when doing something like a shopping system, DO look into session-ids, session-handling, cookies, ip-logging, etc. it isn't as easy as one likes to think. another option would be to print out the html-redirector: ----------------------- print <<EOH; content-type: text/html <html> <head> <meta http-equiv="refresh" content="2; URL=start.pl"> <title> Redirector </title> </head> <body> You'll be redirected in two seconds </body> </html> ---------------- but that is not really necessary because of the http-headers. hope i could help, and feel free to email me if you have more questions (since this topic is kinda offtopic [more of a html/security/perl thing]. Moritz von Schweinitz [EMAIL PROTECTED]
