[sabret00the]

Originally Posted by filburt1

You should use COUNT(), not SELECT *.

[sql]
SELECT COUNT(unique id column name) AS totalcount FROM grps WHERE title LIKE "expression%
[/sql]
It will return a single result row with a column name of totalcount containing the number of matching rows.

Don't forget TABLE_PREFIX.

thanks that fixed it perfectly

Originally Posted by noppid

Using query fiirst returns the first row, not the identifier.

Edited:

seems i should've used query, didn't think of that.