sql auth

pinehead18

$con = mysql_connect("localhost","","") or die(mysql_error());
$db = mysql_select_db("p",$con);
$sql = "SELECT * FROM u";
$result = mysql_query($sql);   

$row = mysql_fetch_array($result);
        $check_user = $row['user'];

if ($check_user == $uname) { header("location: yoda.php"); }

mysql_close();

OK, this is suppose to say if the field user already has a value of $check_user (which is the user name) then go back to yoda.php cuase that username is already taken. however it does not work..

Any suggestions?

helz

as your code stands its only checking the first row of the db, you either need to add a loop into it:

while ($row = mysql_fetch_array($result)) { 
        $check_user .= $row['user'];
}

or (which is better)
you need to change it to make it a little faster while still doing the same job:

$con = mysql_connect("localhost","","") or die(mysql_error()); 
$db = mysql_select_db("p",$con); 
$sql = "SELECT * FROM u WHERE username='$uname' "; 
$result = mysql_query($sql);
$check_user = mysql_num_rows($result);
if ($check_user == 1) { header("location: yoda.php"); }

pinehead18

now that code you gave me is doing it just backwords.

For example.. If their is no user of that name in the db then it tyakes me to yoda.php

But if that username is already taken it adds it.

What should i change on it?

Thank you for your help

helz

change the if statement
if check user is 1 or more it exists in db, if its 0 then it doesnt

so its:
$check_user == 0