Re: How do I fetch result from SELECT COUNT(*) FROM ....

I don't use that particular module but here's my 2 cents worth. --Talwyn

Try

SELECT 
  COUNT(*) AS Order.count 
FROM 
  Orders 
WHERE 
 Orders.Sent=0;

and access it through the field alias
[download]

$count = $RS->Fields('count')->value;

Comment on Re: How do I fetch result from SELECT COUNT(*) FROM .... Download Code

Replies are listed 'Best First'.
Re: Re: How do I fetch result from SELECT COUNT(*) FROM .... by ciamack (Novice) on Jul 01, 2002 at 07:03 UTC
Thanks, It worked fine with a small adjustion: SELECT COUNT(*) AS expr1 FROM Ordes WHERE Orders.Sent=0; $count = $RS->Fields('expr1')->value; expr1 can be anything but Orders.count or count because Orders table doesn't have a 'count' column and word 'count' is reserved in SQL language.	[reply]