Re: Select Count(*) into variable

select count(*) AS numRec, name, town, county from tablename group by telephone I hope this helps. Jayme Jeffman Filho www.conex.com.br/jjeffman -----Mensagem original----- De: Nick Boyle <nick@local-serve.com> Para: php-db@lists.php.net <php-db@lists.php.net> Data: Segunda-feira, 21 de Agosto de 2000 11:28 Assunto: [PHP-DB] Select Count(*) into variable >select count(*), name, town, county from tablename group by telephone, town > >If I wish to do a select (like above), and then process depending on number >of results, how can I put the count(*) into a variable?? > >Many thanks in advance > >Nick > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net >