Re: counting number of records in a MySQL table; how do I get the result?
| From: | Kevin Stone | Date: | Wed, 02 Oct 2002 20:38:56 +0000 |
| Subject: | Re: counting number of records in a MySQL table; how do I get the result? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-118655@lists.php.net to get a copy of this message | ||
$result = mysql_query();
if (mysql_num_rows($result) > $x)
-Kevin
----- Original Message -----
From: "DonPro" <donpro@lclcan.com>
To: "php list" <php-general@lists.php.net>
Sent: Wednesday, October 02, 2002 2:35 PM
Subject: [PHP] counting number of records in a MySQL table; how do I get the
result?
> Hi,
>
> I need to do either an insert or update into a MySQL table. Insert if
there
> are 0 records or update if one record exist:
>
> This is my code snippet:
>
> if (mysql_query("SELECT COUNT(*) FROM AuthNum") == 0) {
> mysql_query("INSERT into AuthNum (FirstNum, LastNum, NextNum) VALUES
> (1,2,3)",$dblink);
> } else {
> mysql_query("Update AuthNum Set FirstNum = 1, LastNum = 2, NextNum =
> 3",$dbLink);
> }
>
> My problem is, a record never gets inserted because the SELECT COUNT query
> is returning a resource ID of 2. How can I get the actual number of
records
> in the table?
>
> Thanks,
> Don
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>