Lars Torben Wilson wrote:
> 2009/1/15 tedd <tedd.sperling@xxxxxxxxx>:
>> At 9:46 AM -0800 1/15/09, Chris Carter wrote:
>>
>> Chris:
>>
>> That's not the way I would do it. After establishing a connection with the
>> database, I would use the query:
>>
>> $query "SELECT email FROM owners WHERE email = '$emailAddress' ":
>> $result = mysql_query($query) or die(mysql_error());
>>
>> if(mysql_affected_rows())
>> {
>> // then report a duplicate email/record.
>> }
>> else
>> {
>> // else insert a new record in the dB.
>> }
>>
>> HTH's
>>
>> tedd
>
> You want to use mysql_num_rows() there instead of
> mysql_affected_rows(). (Just a typo in this case, I suspect, but for
> the benefit of the less experienced it's worth pointing out.)
>
> For the newer PHP users, mysql_num_rows() tells you the number of rows
> you found with a SELECT query, while mysql_affected_rows() tells you
> how many rows you affected with an INSERT, UPDATE, REPLACE INTO, or
> DELETE query.
>
>
> Regards,
>
> Torben
mysql_num_rows() may make more sense, however mysql_affected_rows() will
work the same with a select. The PHP mysql_affected_rows() calls the
MySQL mysql_affected_rows(), which states:
"For SELECT statements, mysql_affected_rows() works like mysql_num_rows()."
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
