If else statement

[Anon]

I have a script that displays the results of a databse query. If there is a partial match in the county column the results will be displayed. What im having trouble with is if the query returns no data how do I display a message letting the user know there was no match.

The script can be seen at
www.rpa-solutions.com/stockist

and the source code at
www.rpa-solutions.com/stockist/index.phps

I know this has something to do with a if else statement but not sure how to approach it.

You help would be most appreciated

[Anon]

I would add something like this

if ($myrow = mysql_fetch_row($result)) {
while ($myrow = mysql_fetch_row($result)) {
do whatever;
}
} else {
echo $error;
}

[Anon]

Cheers that works fine !!

Kind Regards