Re: Need to get total number from query!

Folks: > If you are looping thru each record to print it out, you can add the > value to a variable ($sum = $sum + $number) on each iteration of the > loop. You can also run a second query and extract the result from that. SELECT count(*) AS numbers FROM table; --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409