Shell Programming and Scripting

I want to count the number of occurence of a particular string with spaces from one text file.
I found one posting of a similar kind but looking for a string without spaces, there were lots of reply's which work when the string does not have any spaces between but in my case i must look into a file for a particular string with spaces.
for example a text file will have data:

Code:

no rows selected no rows selected
ora - 1234 error running sql querry
no rows selected

i should look for "no rows selected"
I the above example i should get a count of 3 since we have "no rows selected" string repeated for three times.

the codes which i found in earlier postings are as below:

Code:

awk '{ for (i=1;i<=NF;i++) if ( $i == "abc") c++ } END{ print c}' sample.txt

and

t

Code:

ypeset -i mCnt=0 
mWord='aaa' 
for mEach in `cat input_file` 
do 
if [ "${mEach}" = "${mWord}" ]; then 
mCnt=${mCnt}+1 
fi 
done 
echo 'Total words for '${mWord}' = '${mCnt}

Above codes work when we do not have spaces between.
Any help is greatly appreciated.

Code:

perl -0ne '@m=/no rows selected/g;print $#m+1 . "\n"' file

Code:

nawk '{n+=gsub(str,"")}END{print n}' str='no rows selected' mySampleFile.txt

Thank you for the replies.

Sorry i forgot to mention that i have to write my scripts in ksh.

@ vgersh99: when i tried to run your code it throwed me an error as below:
line 1: nawk: command not found

One more thing, my further code depends on the count generated so we need to put this count in a variable which i will be using further.

If you have Perl installed, then you can run my command in KSH script and assign its output to shell variable...

I do not have perl installed on my machine.

Code:

#!/bin/ksh

str='no rows selected'

num=$(awk '{n+=gsub(str,"")}END{print n}' str="${str}" mySampleFile.txt)
echo "Total number of [${str}] = ${num}"