how to count items searched...

jpfour23

I can't figure this out...

I am developing a search script. I want to be able to list how many 'items' were found within the search per item found.

For instance, if I search a database full of jokes for the word "chicken", how can I display how many times the word "chicken" was found in each joke that has "chicken" in it.

$sql = "SELECT * FROM db WHERE jokes LIKE '%chicken%'"

I can use mysql_fetch_array to figure out each joke and list them how I'd like, but how do I find out how many times "chicken" was found in each joke?

THANKS IN ADVANCE!
Josh

Carello

include somthing like this in your script:

$count = 0;

while(...) {
echo $sql_results_found;
$count = ++;
}

echo "Results: " . $count;

Don't copy and paste it though, insert your own code and SQL statements etc.

jpfour23

I don't think this is exactly what I'm looking for... if so, I'm not understanding what you are doing.

I am wanting to know how many times "chicken" was found in each joke... so when I display it, after searched it might look like this on a web page:

Chicken Joke - submitted by: Josh
(found 18 results)

Why did the Chicken... - submitted by: Ted
(found 6 results)

Does that make sense?

Thanks,
JP

Carello

Oh...sorry, I misunderstood your question.

Anyway, you're probably looking for something like this then:

// String to be searched
$string = "the chicken was yellow like a chicken";
// Prints how many times the defined word was found in the $string
echo substr_count($string,"chicken");

jpfour23

geeze... i should have known it would be easy.

THANKS