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; HTH! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]