Re: IBM's Learning PHP Part 1 tutorial.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2005-07-05 at 22:36 -0400, Bill McEachran wrote:
> Newbie question.
> 
> I'm working my way through IBM's PHP tutorial.  Generally good ... but 
> I'm stuck at an error point and have no idea what's going wrong.
> Before adding a new row to the mysql database (already opened) we do a 
> query to see if a particular record already exists.
> (see $resultT).
> 
> 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 /*
> 

Although I'm not sure that will work, mysql_num_rows( $resultT ) == 1
will tell you for sure if the user exists or not.

Just remember to addslashes() to $_POST['name'] before doing that query,
so SQL can't be injected.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux