Mysql_result gives an error about the param. value passed to it

[rotten69]

Hey guys,

I don't see anything wrong in the function but mysql_result is complaining about the parameter value passed to it.

function question_exists($question_id){

    $question_id = (int)$question_id;
    return ( mysql_result(mysql_query("SELECT COUNT('id') from `posts`  WHERE `id`=$question_id"),0) == 0) ? false : true;

    // if the question doesn't exist (equal to ZERO) then return false. Else, return true
}


    $id = '20';

    question_exists($id) =>  this gives me this message "Warning: mysql_result() expects parameter 1 to be resource, boolean given "

Thanks in advance for the help!

[rotten69]

Any quick help?

[pritaeas]

COUNT('id')

Change single quotes to backticks.

[rotten69]

I tried using (id) but this doesn't seem to be working

[GliderPilot]

Disregard.... just DaniWeb changing the post above on me so it's already been done

[GliderPilot]

Sry for double post I took a look and it won't let me re-edit the above post.

You're getting that error because your query has failed. When it fails it returns FALSE hence the boolean error.

I would break your query down and add error handling to help identify the issue

$sql = "SELECT COUNT(`id`) FROM `posts`  WHERE `id`=$question_id";
$result = mysql_query($sql) or die (mysql_error());

[rotten69]

I fixed it already. Cheers for the help, guys.