[PHP] Re: counting number of records in a MySQL table; how do I get the result?

[OrangeHairedBoy]

Hi!

$result=mysql_query("select count(*) as count from AuthNum");
$a_row=mysql_fetch_object($result);
$NumberOfRows=$a_row->count;

if ($NumberOfRows)
    {
    /* There is at least one row */
    }
else
    {
    /* There are no rows */
    }

Hope this helps (especially the "as count" part in the query)

::Lewis

"Donpro" <[EMAIL PROTECTED]> wrote in message
073901c26a53$44fdaaa0$[EMAIL PROTECTED]">news:073901c26a53$44fdaaa0$[EMAIL PROTECTED]...
> 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