<?php
// Connects to your Database
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());;
 
$uname = $_POST['uname'];
$pword = $_POST['pword'];
//gets username and password from uname and pword fields on previous page
 
$result = mysql_query("SELECT * FROM logins WHERE uname='$uname'");
 
if($row = mysql_fetch_array($result))
  {
  setcookie("loggedin", "$uname", time()+3600);
  echo "logged in as: ";
  echo $row['uname'];
  echo "<br />and cookie written.";
  echo "<br />";
  echo 'click <a href="cookie.php">here</a> to view cookie information.<br/><a href="login.php">Back to login page.</a>';
  }
else
{
echo "wrong login information";
}
?>

SELECT * FROM logins WHERE uname='$uname' AND password='$pword'

//run query here
if (mysql_num_rows($result) == 1) {
  //then log the person in
}
else {
  //they have invalid credentials
}

$result = mysql_query("SELECT * FROM logins WHERE uname='$uname'");

$result = mysql_query("SELECT * FROM logins WHERE uname='$uname' and pword='$pword'");