Login Check with mysql

[Asuka]

Well here is the problem
I made a site and then I want a member login som I cant track the stuff they upload and download
The system is basic based on a cookie there tells he/she is login but the deal is I need it to tell if the login is worng then it look it up in the mysql database
So I need a way to compere
$value1 there is username
$value2 there is password
to the rows in the database
I tryed
$query = SELECT username
FROM user where username = "$value1" and password = "$value2"
if ($query = $value1) {
something; }
else {
echo "error Worng login";
}

if someone can help I would be very happy

[devinemke]

you are never running your query

$query = "SELECT username FROM user where username = '$value1' AND password = '$value2'";
$result = mysql_query($query) or exit(mysql_error());
if (mysql_num_rows($result)) {echo 'welcome';}
else {echo 'no records found matching that username and password';}

[Asuka]

<?php
$use = $HTTP_GET_VARS[us];
$pas = $HTTP_GET_VARS[pa];
require_once "connect.php";
mysql_select_db("test") or die("kunne ikke vælge databasen");
$query = "SELECT * FROM user where username = '$use' AND password = '$pas'";
$result = mysql_query($query) or die("Forespørgslen lykkedes ikke : " . mysql_error());
$r = mysql_fetch_array($result);
$welcome = $r["username"];
if ($welcome = $use) {
echo "login 100%";
} 
else { 
echo "**if no data";
} 
?>

did this it work but dam my code look ugly compere to urs ^_ but thanks for the help, I probly gonna be back with more later on