Having trouble reiterating through search records

I have been doing Mitchells tutorial on adding a php search facility to your site - including modifying the searchdocs.php file, although only slightly to suit databases already online.

I only receive one result for display. It is always the last article (or "JobId") in the select query...

I think the placement of the '$count' or '$count++' may have something to do with my problem.

I also do not think that my keywords are being exploded (same again - seems to be using the last keyword entered also...)

Other possible fault is there SELECT query syntax on the WHERE clause.

Thanks for any help.

I've been able to get listings for each article category, although there is still only the final article displayed for the select statement....

I've atteched the code that has gotten me to this point.

NB: I have reworked the table_column_names to suit Mitchells tutorial and this has helped some.

GreenHornet,

Do you have a site where I can check out the results? I've looked through the code, and I can't seem to locate the problem... Mind you, this is after a night out on the town, so I may not be reading things properly this morning!

Seriously though, if you have a site where I can check it out, it may help me determine the problem.