David,
try
1) create temporary table x (a INT PRIMARY KEY AUTO_INCREMENT)
[select_statement]
where [select_statement] is some legal select statement, presumebly
select g.Description,sum(i.Retail_Value)
from Groups g, Item i
where i.Group_ID =g.Group_ID
and i.Group_ID 0
group by i.Group_ID
order by i.Category_ID;
then
2) select * from x
When you close the connection the trmporary table x will be removed. The
same temporary table name can be used for multiple connections.
Otherwise get the resultset into your application, and then increment a
counter in a for/while loop etc
Regards,
Dan
-Original Message-
From: David S. Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 12:08 p.m.
To: [EMAIL PROTECTED]
Subject: Re: how do you increment a field on the fly?
How do you add a column that increments on the fly those fields
you've selected to print in a mysql query?
Example:
select count(g.Group_ID) as Number, g.Description,
sum(i.Retail_Value) from Groups g, Item i where i.Group_ID =
g.Group_ID and i.Group_ID 0 group by i.Group_ID order by
i.Category_ID;
My intention was to have the Number field simple be a number that
increments by one for each line that prints out. But, of course,
the documentation says that's not what the count function is
for.
How can I add a simple little old line counter?
--
David S. Jackson[EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
I put instant coffee in a microwave and almost went
back in time. -- Steven Wright
--
David S. Jackson[EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
I'm not afraid of death -- I just don't want to be
there when it happens.
-- Woody Allen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php