CODEWITHSUNDEEP
phpmysqlsqlmysqli
user3685680
user3685680

Reputation: 1

php if statement always returns false

I know this is a really basic question but I am completely at my wits end. I have been working on this for two days. The if statement always returns false. I have tried === and == and copy to an $array and process outside the fetch $result loop. I have compared to a direct "name". I have outputed the ascii value of each letter of the returned string and compared that way to make sure I wasn't putting a space or something in somewhere. I've tried mysql and mysqli ways. I've tried OO style and Procedural style but here's the rub, This code was copy and pasted from my own site where it's working just fine in three other programs in my site.

<?php
SESSION_START();
if(!isset($_SESSION["uname"])){
require ('redirect.html');
die();
}// session is set close
$uname = $_SESSION["uname"];

$user_name = "xxxxxx";
$password = "xxxxxxx";
$database = "usersdata";
$server = "xxxxxxxxxx.ipagemysql.com";


$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "SELECT * FROM messages";
$result = mysql_query($SQL);

while ( $db_field = mysql_fetch_assoc($result) ) {

//echo out values for visual comparison
echo $db_field['recipient']." ".$uname." ";

if($db_field['recipient'] === $uname){echo " match ";} else {echo " no match ";}

}// while loop db_field close
}// if db_found loop close

mysql_close($db_handle);

?>

As I stated this code works just fine in three other programs running on this very site. All I did was copy paste and change the db and fields. I even tried retyping it all from scratch just to make sure. Help me I'm melting....

Upvotes: 0

Views: 91

Answers (1)

Hanky Panky
Hanky Panky

Reputation: 46900

Why would you return all the messages and then compare with every single message if the name matches. You can simply add a where clause to your query

SELECT * FROM messages WHERE recipient='uname value here'

Then you can check for the number of rows returned. If 0 rows are returned, there was no match.

Upvotes: 2

Related Questions