Resource ID 5

[slj90]

This works...

$result = mysql_query("SELECT * FROM login_attempts");

while($row = mysql_fetch_array($result)) {
$diff = strtotime($row['login_date'])-time();

if ($diff > -300){
$count = $count + 1;
} 

if ($count > 4) {

$result = "locked";
}
}

This returns Resource ID 5...

 

$result = mysql_query("SELECT * FROM login_attempts WHERE login_username='$username'");

while($row = mysql_fetch_array($result)) {
$diff = strtotime($row['login_date'])-time();

if ($diff > -300){
$count = $count + 1;
} 

if ($count > 4) {

$result = "locked";
}
}

What's the problem?

Many thanks,

[Barand]

At a guess, in the first one the count exceeds 4 so $result gets overwritten with "locked".

 

In the second the count doesn't exceed 4 so $result retains the query resource id value it received when you executed the query.

 

Don't reuse the $result variable.