RE: [PHP] counting number of records in a MySQL table; how do I get the result?
| From: | John W. Holmes | Date: | Wed, 02 Oct 2002 22:52:21 +0000 |
| Subject: | RE: [PHP] 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-118674@lists.php.net to get a copy of this message | ||
> $result = mysql_query();
> if (mysql_num_rows($result) > $x)
> -Kevin
This won't work because a SELECT COUNT(*) query always returns a row,
even if it returns zero as the value.
$result = mysql_query("SELECT COUNT(*) FROM ... ");
$count = mysql_result($result,0);
---John Holmes...
> ----- 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
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php