RE: [PHP] IBM's Learning PHP Part 1 tutorial.
| From: | Jay Blanchard | Date: | Wed, 06 Jul 2005 13:08:26 +0000 |
| Subject: | RE: [PHP] IBM's Learning PHP Part 1 tutorial. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218199@lists.php.net to get a copy of this message | ||
[snip]
We then test, using if, to see if $resultT is true or false. If it's
false we are then supposed to enter a new record.
Problem: it's never false. It always evaluates true. What am I doing
wrong? TIA
/* build query to see if the record is entered already */
$sqlT = "select * from users where
username='".$_POST["name"]."'";
$resultT = mysql_query($sqlT);
/* Now test -- did we find anything ... if not add this user */
if (! $resultT) {
/* here we add the new record if it doesn't already exit /*
[/snip]
You have set $resulT like this;
$resultT = mysql_query($sqlT);
So it will always be true. What you want to do now is find if $resultT
contains any rows;
if(0 != mysql_num_rows($resultT)){
/* add record */
} else {
echo "Record already exists\n";
}