[snip] You will have to do two things, set a variable to zero and then add to it on each iteration. Yes...those are variables and that is a colon in the SELECT statement.
SET @count=0; SELECT @count:[EMAIL PROTECTED], this_column, that_column, etc FROM your_table; [/snip] I should have mentioned this...VERY IMPORTANT!!! If you do not issue the SET again after running this query and you are in the same SQL session the numbers will continue to add up. You must clear the variable (SET @count=0;) each time! HTH! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
