Count()

[D_tunisia]

Can someone tell me how to use the Count() function please?

I've got two fields ($id and $text).

I want to look at the $text field and find out the number of times an entry is there.

For example, if the code finds the phrase "email address" in the $text field 10 times, then it should output that.

[jonno946]

count() is for counting elements in arrays.

you want to be using the substr_count string function.

http://uk.php.net/manual/en/function.substr-count.php

<?php
echo substr_count("this is a test this is a test", "test"); // prints out 2
?> 

[D_tunisia]

Thanks, but I don't think I explained it clearly enough.

Say I have this:

id | text

1 hello
2 hello
3 goodbye

I want to have a script that looks at the table and then outputs:

hello x 2
goodbye x 1

[jonno946]

ok... see if this works...

$query = mysql_query("SELECT text, count(*) AS number_of_occurances FROM mytable GROUP BY text");

while($result = mysql_fetch_assoc($query)) {

echo $result[number_of_occurances] . " x " . $result[text];

}

[D_tunisia]

Originally posted by jonno946
ok... see if this works...

$query = mysql_query("SELECT text, count(*) AS number_of_occurances FROM mytable GROUP BY text");

while($result = mysql_fetch_assoc($query)) {

echo $result[number_of_occurances] . " x " . $result[text];

}

[/B]

IT BLOODY WORKS!! THANKS!

I've been working on that for days!