count search results previously

Posted by urwen on March 12, 2008 at 11:08pm

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.

Comments

User this code to get result

Posted by naveenpl on March 13, 2008 at 4:11am

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.