$conn = $main; <- that line is the problem - you cant use global vars
inside functions without declaring them as global
----- Original Message -----
From: "Stephen Craton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 28, 2002 11:49 PM
Subject: [PHP] Member's Area Script
> Hello again,
>
> I'm trying to write a script that has a member's area in it. So far I've
> been able to successfully validate only one username and only one
> password but now I'm going big and trying to compare it with a table in
> my MySQL database. Everything goes nice and smooth until I actually try
> and enter in my username and password. I type it in, copy and paste,
> whaetever and it tells me the error I wanted it to say "The username and
> password is not a good combo." I've copied and pasted the username and
> password from the database directly yet it still gives me this error.
> Here's my code for the login() function that logs the user in:
>
> function login($username, $password)
> {
> $conn = $main;
> if (!$conn)
> return 0;
>
> $result = mysql_query("select * from user
> where username='$username'
> and passwd = '$password'");
> if (!$result)
> return 0;
>
> if (mysql_num_rows($result)>0)
> return 1;
> else
> return 0;
> }
>
> Here's the code for the part that calls the login() function:
>
> if(login($user, $pass))
> {
> $valid_user = $user;
> session_register("valid_user");
> }
> else
> {
> echo "<font face='Arial, Helvetica, sans-serif'
> size='3'><center><b>You supplied an invalid username and password combo.
> Try again please.</b></center>";
> exit;
> }
>
> And here's the part that connects to the database:
>
> <?php
> # FileName="Connection_php_mysql.htm"
> # Type="MYSQL"
> # HTTP="true"
> $hostname_main = "localhost";
> $database_main = "mom";
> $username_main = "root";
> $password_main = "";
> $main = mysql_pconnect($hostname_main, $username_main, $password_main)
> or die(mysql_error());
> ?>
>
> Does anyone see why it's doing this to me? Please help!!
>
> Thanks,
> Stephen
> http://www.melchior.us
> http://php.melchior.us
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
