Getting query to work

[M8KWR]

I am new to PHP so please bare with me; i have the following code which i have put together using several websites but i can not seem to get it to work.

<?PHP
$TPSNUMBER = $_POST['TPSNum']; // carry the variable from the user input TPSNum
$db = mysql_connect("localhost","Username","Password"); // host / username / password
mysql_select_db("tps",$db);

$sql_result = mysql_query("SELECT `phone1` FROM `tps` WHERE `phone1` = $TPSNUMBER", $db); // query

$result = mysql_query($sql_result);

if ($result) {
    while ($array= mysql_fetch_assoc($result)) {
        echo "The number was found";
    }
} else {
    echo "No results found";
}

?>

Even though i am using a value that i know is in the table, it is always bring "No result found".

I am assuming it is something really simple, but i can not see it for love or money!!!!

Thanks in advance

 

[sleipnir214]

If the line outputting the mesage "No result found" is being run, then the if-statement is evaluating to FALSE.

If the if-statement evaluates to FALSE, it is because $result has the value FALSE in it.

The value in $result got there from the invocation of mysql_query(). The PHP online manual page for mysql_query() clearly states, "For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error."

Thus, I conclude your query has an error of some kind. Please see section 1.5 of faq434-2999 for advice on debugging database-access PHP code.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[jpadie]

consider also enquoting and escaping variables in the where statement,

 

[jomuga]

Have you tried placing your variable in quotation marks? Something like this:
"SELECT `phone1` FROM `tps` WHERE `phone1` = '".$TPSNUMBER."'