> >SELECT COUNT(x) FROM table; > > > >Make 'x' equal to any column name in the table and add WHERE to the > >clause as needed. > > err...all very well, but how do i retrieve the > value afterwards?
> $sqlcom="select count(codigo) from comments where > codigo=$id"; SELECT COUNT(codigo) AS SomeName FROM comments WHERE codigo='$id' Then you'll have 'SomeName' to play with. CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php