Question: mysql_num_rows

[bluefrog33]

Problem solved.

Thank you for all your help! I have found the obvious mistake in my script!

[halojoy]

my guess is that this function
return FALSE
if there is no result
[man]mysql_num_rows/man

🙂

[bpat1434]

Alternatively you could just execute this query, and see whether the returned result is 1 or 0:

SELECT COUNT(*) AS `count`
FROM `table`
WHERE id='1234'

Then do:

if(mysql_result($result, 0, 'count') == 0)
{
    $map = 'No';
} else {
    $map = 'Yes';
}

[bradgrafelman]

Why did you remove the content of your post? Leaving your post alone so that others can see the error and solution might aid those in the future who are searching for an answer to a similar problem.

Also, to mark a thread resolved, please use the link on the Thread Tools menu (editing the tittle of your initial post doesn't actually change the thread's title).