PHP login skript

if(isset($_REQUEST['login']))
  {
  $login = Trim(stripslashes($_POST['login']));
  include('/var/www/secret.php');

  $con = mysql_connect("localhost","admin",$pass_base);
  if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }

  mysql_select_db("baza", $con);

  $result = mysql_query("SELECT * FROM admin");
 
  while($row = mysql_fetch_array($result))
    {
      $ok = $row['password'];
    }

  mysql_close($con);

  if($ok != $login)
    {
      die('Incorect password!');
    }
  
// snip snip
  
  }
else
  {
  echo "<form method='post' action='admin.php'>
  Admin Password: <input name='login' type='password' /><br />
  <input type='submit' />
  </form>";
  }

Ja, za enkrat je samo ena vrstica ker nimam več userjev zaenkrat.

<?php
$nick = mysql_real_escape_string($_POST['nick']);
$sql = "SELECT * FROM
    users
WHERE
    up='" . $nick . "'
LIMIT 1";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

if($row['pass'] == $_POST['pass']) {
    echo 'Uspesna prijava!';
} else {
    echo 'Neuspesna prijava!';
}
?>

$host="localhost"; // Host name

$username=""; // Mysql username

$password=""; // Mysql password

$db_name="test"; // Database name

$tbl_name="members"; // Table name

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

Ne skapiram teh sej.

$connect = mysql_connect("localhost", "$username", "$password")or die("cannot connect to database");

javi mi, da ta username se ne more povezat na bazo. Je pa res da imam bazo na "W" ne na "C" particiji. Ima to kake veze?
Ne vem zakaj se pol ne more prijavit v bazo. Baza je ok.

<?php
include("connect.php");

mysql_select_db("my_db", $con);

$a= "'$_POST[firstname]'";
$d= "'$_POST[lastname]'";

$result = mysql_query("SELECT LastName FROM Persons WHERE FirstName='$a'");
echo "$result";
if ($result == $d)
echo "pravilno logiran";
else
echo "napaka";

mysql_close($con);

?>

$a= "'$_POST[firstname]'";
$d= "'$_POST[lastname]'";

$a= $_POST['firstname'];
$d= $_POST['lastname'];