Re: Select Count(*) into variable

Nick Boyle wrote: > 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?? $query = "select count(*) AS foo, name, town, county from tablename group by telephone, town"; (assuming MySQL, though it may be true for others as well...) > > > 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