[RESOLVED] read table data until true?

[IceRegent]

I have to read data from a table until two statements are true. I dont know how to break out of the loop when I find the true statements. Here is the code:

<?php
// set-up database connection
include "db_config.php";
mysql_select_db(iceregen_MStudio);

// check for propper login from users table

$query  = "SELECT  UserID, UserName, password FROM users";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

if ($row['UserName'] == $LoginName AND $row['password'] == $pword)
{
echo 'username and password are valid';
	}
else 'Invalid UserName and/or Password';
}
?>

I'm sure it's something simple, but i cant find the answer anywhere.

Thank you;
Ice

[mercrapper]

Try this :

if ($row['UserName'] == $LoginName AND $row['password'] == $pword)
    {
echo 'username and password are valid';
break;
    }
else 'Invalid UserName and/or Password';
} 

[IceRegent]

Aye! A break command! Ok, I understand. So I can use a break command to interupt the cycle of data reads when I come accross a condition that is true. Thank you. I will give that a try and see how it runs for me.

Thank you!
Ice

[IceRegent]

Well, that worked, but where does the php go when it hits the break? And, where does it go to when the statement is invalid, and it reaches the end of the user table? How do I tell it to go back to the login page if its reached the end of the table's and not found any true statements?

Thanks;
Ice

[Nadzree]

I think it will go nowhere..erm..just give the command where will the page go when statement is true...

$redirectLoginSuccess = "Success.php";
$redirectLoginSuccess = "UnSuccess.php";

if ($row['UserName'] == $LoginName AND $row['password'] == $pword)
{
echo 'username and password are valid';
header("Location: " . $redirectLoginSuccess );
break;
}
else 'Invalid UserName and/or Password';
header("Location: " . $redirectLoginUnSuccess );
}

I think so...sorry if i'm wrong..

[IceRegent]

That worked except that I had to remove any output messages before I did the header command. Thanks!

Ice