trying to create a login page but keep getting a No database selected error

[numerical25]

Im trying to create a login form that ask for login name and password. once submited, the form submits to the same page again but assigns the value 1 to the URL varible. An If statement gets the URL varible and begins to check if the login name and password is correct. See script below

Below starts a session. if the user session is not defined the display the login form.

<?php session_start(); ?>
	<?php if ( !isset($_SESSION['user'])){ ?>
	<table border="0" cellspacing="0" cellpadding="0">
	<form action="admin.php?admin=1" method="post">
  <tr>
    <td width="82">Login:</td>
    <td width="144"><input type="text" name="loginName" /></td>
  </tr>
  <tr>
    <td>Password: </td>
    <td><input type="password" name="password" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="Submit" value="login" /></td>
  </tr>
  </form>
</table>
	<?php } ?>

Below takes the URL varible admin checks to see if its defined and if so it opens a connection to MYSQL. the require_once was made by dreamweaver to get the connection.

<?php if ($_GET['admin'] == 1){ ?>
	<div id="admin">
			<?php require_once('Connections/ok.php'); ?>
			<?php $query = "SELECT loginName, passWord
						FROM users
						WHERE passWord = '{$_POST['password']}'";
				  mysql_select_db(database_ok,$ok);
	$results = mysql_query($query,$ok) or die("Query failed ($query): " . mysql_error()); 

			  $check = mysql_fetch_assoc($results);
			  if (strcasecmp($check['loginName'],$_POST['loginName']) == 0 
			  		&& strcmp($check['passWord'],$_POST['password']) == 0) {
					echo "success";
					}else { echo "Wrong"; }
						?>
</div>
<?php }?>

IN the end , I get the error below...

Query failed (SELECT loginName, passWord FROM users WHERE passWord = 'useradmin'): No database selected

[devinemke]

in this line...

mysql_select_db(database_ok,$ok);

have you previously defined a constant called "database_ok" or is that the literal name of your db? if it is the literal name then in needs to be in quotes.

[numerical25]

I figure out the problem. See below

<?php if ($_GET['admin'] == 1){ ?> 
    <div id="admin"> 
            <?php require_once('Connections/ok.php'); ?> 
            <?php $query = "SELECT loginName, passWord 
                        FROM users 
                        WHERE passWord = '{$_POST['password']}'"; 
                  mysql_select_db(database_ok,$ok);   //<----instead of placing it here

$results = mysql_query($query,$ok) or die("Query failed ($query): " . 

<?php if ($_GET['admin'] == 1){ ?> 
    <div id="admin"> 
            <?php require_once('Connections/ok.php'); ?> 
            <?php  mysql_select_db(database_ok,$ok); //<<---I placed here and it works
                   <?php $query = "SELECT loginName, passWord 
                        FROM users 
                        WHERE passWord = '{$_POST['password']}'"; 
                //  mysql_select_db(database_ok,$ok); <<------It use to be here
    </div> 
    <?php }?> 

But now I have another issue. for some reason the resources arnt going into the varible $check . instead its querying this out

Resource ID#4

At least thats what it shows when I echo the varible out.
But as you can see from above, i fetch the results and put it into $check.
If I dont put nothing into the form, then I get a success. If I put anything into the form regardless if its the right password or not, I get a wrong!

[bradgrafelman]

EDIT: Okay... apparently there's a different thread for this issue...

[numerical25]

ok i figure it out, nevermind