Search results - How many?

[chrislead]

I have implemented a simple search facility that links up to my database and displays some items.

I want to now display on the page where it shows these results, how many results (records) have been found.

Hope you know what I mean and am greatful if anyone can help me out. Thanks

[pablodelapena]

mysql_num_rows() is probably the answer you are looking for?

[chrislead]

Yes I have used that for another section of my site, that deals with MYSQL and worked perfect, thanks. However, I am now wanting to do the same with a database connected through ODBC. I realise that there is the equivalent; odbc_num_rows, however it always displays -1. If there is any help regarding that matter I would be most greatful. Thanks again.

[pablodelapena]

i dont do much other than with MySQL, but having looked at the docs within 5 seconds i saw what your problem is. It always returns -1 which means that it is returning an error. Have a look further up your code and see if you can see what is wrong, you might have an illegal call or something.

If you cant find anything try posting the actual code on here and see if either myself or anyone else can spot it. quite often it helps to have someone else proof read code.