[SOLVED] Count the instances...

[me1000]

---

Is there a PHP function that counts the number of time something appears in a MySQL query?

So I run the query, and it finds the number of times "

---

" is found in the returned results.

 

[marcus]

---

Something like:

 

$sql = "SELECT * FROM `tbl_name` WHERE `field_name` LIKE '%

---

%'";
$res = mysql_query($sql) or die(mysql_error());
echo mysql_num_rows($res);

 

??

[me1000]

---

That gives me back the number of entries with '

---

' in it.

I just need to find the number of times '

---

' is found within one entry

[me1000]

---

ok I think i have it,

 

$pages = explode("

---

", $info);
foreach ($pages as $v) {
    $i++;
}
echo $i-1;