in reply to Re: How do I fetch result from SELECT COUNT(*) FROM ....
in thread How do I fetch result from SELECT COUNT(*) FROM ....

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.
  • Comment on Re: Re: How do I fetch result from SELECT COUNT(*) FROM ....