count search results previously
urwen - March 12, 2008 - 23:08
Hi,
i´de like to show the number or count of results for a particular query before redirecting the user to /search/nodeprofile_search/spain, for example.
The idea is to show a list with this information:
spain (2)
france(1)
morocco(4)
where this numbers are the number of results for the query. is it possible to do this in an easy way? If not, which api or where should i look for more information?
Thanks a lot in advance.
User this code to get result
User this code to get result count
db_num_rows(db_query( "SELECT * FROM {your_table_name}WHERE columnname = '%s'" , $variable));
Hope this will help
Cheers.