Re: [PHP-WIN] Probably there is better solution

2001-01-11 Thread Gonzalo Vera
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_

Re: [PHP-WIN] Probably there is better solution

2001-01-11 Thread kill-9
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

Re: [PHP-WIN] Probably there is better solution

2001-01-11 Thread Jan Walter
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

[PHP-WIN] Probably there is better solution

2001-01-11 Thread afan
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