Check out mysql_num_rows and the COUNT function in MySQL: both are
good, quick ways of getting that number without looping through your
whole result set.
Gonzalo.
> Hi all,
> I have to know how many entries I have in table/database. Usually, I use
> $result = mysql_query("SELECT any_name_of_
mysql and php needs
- Original Message -
From: "afan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 9:24 PM
Subject: [PHP-WIN] Probably there is better solution
Hi all,
I have to know how many entries I have in table/database. Usu
afan wrote:
> I have to know how many entries I have in table/database. Usually, I use
>
> $result = mysql_query("SELECT any_name_of_column FROM table_name", $db);
> while($myrow = mysql_fetch_array($result));
> {
> $Counter++;
> }
> echo"No of entries: $Checker\n";
Hi Afan,
try query SELE
Hi all,
I have to know how many entries I have in table/database. Usually, I use
$result = mysql_query("SELECT any_name_of_column FROM table_name", $db);
while($myrow = mysql_fetch_array($result));
{
$Counter++;
}
echo"No of entries: $Checker\n";
Probably there is better and faster soluti