user authentication

[DeMuro1]

ok so I'm still pretty fresh to php and MySQL, but I want to do a few things and I'm a little uncertain of a few things so firstly

In this little piece of script, when the database is queired, does username and password need to match for a value other than 0 to be stored in $num....

Also I see the variable $valid all over the plave in tutorials. I've seen it equal tons of things among which are.....good, ok, bad, valid, no.

So my second question-isthe variable $valid a special variable or do people just use it and assign whatever values they want for easy use later on....what would be the benifit of this?

Thanks


$sql = "SELECT * FROM users WHERE username='$user' and password='$pass'";
$result = mysql_query($sql);
$num = mysql_numrows($result);
if($num != "0") {
$valid = 'yes';




Also...does anyone know what

echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"1; URL=index.php\">";

That is

[Gavin B.]

When mysql returns the number of rows, if the username and password both match there will be 1 row. Otherwise no results are returned so the result is 0 :) So yes, the username and password need to match for 1 to be returned.

$valid is just a variable people use, nothing special about it, it's just convenient.

The last piece of code you have there is the HTML meta tag which redirects (or refreshes) a page. The one you have above waits 1 second (CONTENT=\"1\") then redirects the user to index.php

in case you're wondering about the backslashes \ they are there to 'escape' the quote marks " which would confuse PHP (as it's being echo'd out). It looks like this once it's been echo'd:
<META HTTP-EQUIV="Refresh" CONTENT="1; URL=index.php">

[DeMuro1]

cheers....I thought as much but I wasn't certain thanks for the help