[RESOLVED] check if user in db only works on the second attempt

[cneeds]

Hello everyone.

I'm new here and to php!

I have this code in my 'check_exists.php' file:

<?php

$userID = $COOKIE['userID'];
$entity = $COOKIE['entity'];
$password = $_COOKIE['password'];
$row['user_first_name'] = $userID;
$row['user_last_name'] = '. Please complete this form to register';
$result = mysqli_query($link, 'SELECT * FROM users_table WHERE user_ID="' . $userID . '" And user_entity="' . $entity . '" And user_password="' . $password . '"');

if ($result) {
$row = mysqli_fetch_array($result);
}
echo 'Welcome ' . $row['user_first_name'] . ' ' . $row['user_last_name'];

?>

The first problem is that it only welcomes me the second time I enter existing user data. It feels like the mysqli_query doesn't finish before the rest of the code is executed!?

Secondly, $row gets cleared even when 'if ($result)' is false, so I never see 'Please complete this form to register'.

Please help me with these issues if you can.

Best regards

Chris

[dagon]

your using the set cookies values that wont exist untill the page reloads as they are part of the http header, why not just use the form values

you overwrite $row with the query results.

[cneeds]

Hi dagon

Thank you, you solved my first problem!!

---

In the code
if ($result) {
$row = mysqli_fetch_array($result);
}
if $result is false then $row is not affected? or does it get cleared either way?

Chris

[dagon]

$result will be true if its a valid query, regardless of the number of rows returned.

[cneeds]

Sorry dagon, even if no rows are returned?

Chris

[dagon]

mysqli_query