RE: [PHP] run query

2002-12-10 Thread Jon Haworth 
Hi Diana,

 After I run a query lik this,
 $db-query($sql);
 
 what is the quickest way to find out how many 
 records result? 

Look into mysql_num_rows (or the equivalent if you're not using MySQL)

Cheers
Jon

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] run query

2002-12-10 Thread @ Edwin 
Or,

Jon Haworth [EMAIL PROTECTED] wrote:

 Hi Diana,
 
  After I run a query lik this,
  $db-query($sql);
  
  what is the quickest way to find out how many 
  records result? 
 
 Look into mysql_num_rows (or the equivalent if you're not using MySQL)

... you can even do it faster by using a

  select count(*) as something from some_table

More info (found in the manual):

  http://www.faqts.com/knowledge_base/view.phtml/aid/114/fid/12

HTH,

- E

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] run query

2002-12-10 Thread Rich Gray 
Er... but the original poster wanted a count of rows returned by a
particular query... your method just returns the number of rows in the
table...

Rich

-Original Message-
From: @ Edwin [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 17:21
To: Jon Haworth; 'Diana Castillo'
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] run query


Or,

Jon Haworth [EMAIL PROTECTED] wrote:

 Hi Diana,

  After I run a query lik this,
  $db-query($sql);
 
  what is the quickest way to find out how many
  records result?

 Look into mysql_num_rows (or the equivalent if you're not using MySQL)

... you can even do it faster by using a

  select count(*) as something from some_table

More info (found in the manual):

  http://www.faqts.com/knowledge_base/view.phtml/aid/114/fid/12

HTH,

- E



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] run query

2002-12-10 Thread @ Edwin 
Oops, ok, I misread the original question :)

Rich Gray [EMAIL PROTECTED] wrote:
 Er... but the original poster wanted a count of rows returned by a
 particular query... your method just returns the number of rows in the
 table...

Anyway, you're right. If you already have a result then use
mysql_num_rows().

- E

...[snip]...

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php