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<br>\n";

Hi Afan,

try query SELECT COUNT(*) FROM table_name.
--
__________________________________________________________________________________________

==========================================================================================

Jan Walter, called John
LERACH, s.r.o.
phone nr. work: +420-2-78 22 619, home: +420-2-35 35 27 61
on emergency call cell phone: +420-602-385 760
work e-mail mailto:[EMAIL PROTECTED]
private e-mail mailto:[EMAIL PROTECTED]
ICQ#: 28353428
__________________________________________________________________________________________

==========================================================================================




-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to