Log-in script

[sonfohud]

I all ready have an SQL database I would like to use....

Here is what I tried using, but its not working....any ideas?

<form method=post action=="<?echo $PHP_SELF?>">
<table cellpadding=2 cellspacing=0 border=0>
<td><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">Username:</font></td>
<tr>
<td> <input type="text" name="username" size=8></td>
<tr>
<td><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">Password:</font></td>
<tr>
<td><input type="password" name="password" size=8></td>
<tr>
<td><input type="submit" name="submit" value="Log In"></td>
</table>
</form>

<?php
$username="name";
$password="pass";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
if ($submit) {
$query="select DISTINCT username, user_password FROM phpbb_user_group, phpbb_users WHERE (phpbb_user_group.group_id= '4') AND (phpbb_user_group.user_id= phpbb_users.user_id) ORDER BY username ASC";
$result=mysql_query($query);
while ($row=mysql_fetch_array($result)) {
if ($row["password"]==$user_password) {
{

echo "Successfully Logged In!";

}
}
}
?>

[kevinsequeira]

hm, at a glance ...

$username="name";
$password="pass";
$database="db";

u have used the same names for the user/pwd to your database and in your form, so these values are over-writing whatever u fill up in the form

change to

$uname="name";
$pwd="pass";
$database="db";

mysql_connect(localhost,$uname,$pwd);

reg
kevin

[lanjoky]

SEE Kevin's post above as well ... this may make a difference as well..

<?php 
$username="name"; 
$password="pass"; 
$database="db"; 

$connection = mysql_connect(localhost,$username,$password); 
@mysql_select_db($connection, $database) or die( "Unable to select database"); 
if ($submit) { 
      $query="select DISTINCT username, user_password FROM phpbb_user_group, phpbb_users WHERE (phpbb_user_group.group_id= '4') AND (phpbb_user_group.user_id= phpbb_users.user_id) ORDER BY `username` ASC"; 
     $result=mysql_query($connection, $query); 
     while ($row=mysql_fetch_array($result)) { 
             if ($row["password"]==$user_password){ 
                    echo "Successfully Logged In!"; 
              } 
      } 
} 
?>

Try that and see if that doesnt help if it doesnt post and I will look at it more in depth

[sonfohud]

well...i changed the $username and $password like you said and now i get unable to connect to the database.

[lanjoky]

post the new code so we can see what u did
thanks