[RESOLVED] function returns weird value?

[jasondavis]

function blog_is_subscribed() {
    $sql = "SELECT COUNT(autoid) FROM friend_blog_subscrib
                WHERE userid='" . $_SESSION['info']['auto_id'] . "'
                    AND subsuserid='$rowSelect[userid]'
                LIMIT 1";
    $result = executeQuery($sql);
    return mysql_result($result, 0) != 0;
} 
if(blog_is_subscribed()){
$notifications = 1;
} else {
$notifications = 2;
}
echo $notifications;

No matter what $notifications = 2; if a result is found or not, do yuo see anything wrong?

[jasondavis]

ahh got it $rowSelect[userid] is not passed into the function

[halojoy]

hi
I dont know about you ......
But I would never be working with my php scripts without
error_reporting( E_ALL );

I am pretty sure such question you ask in this topic
would have been told by error reports from PHP.

<?php

error_reporting( E_ALL ); // Full PHP error reports!

function blog_is_subscribed() {
    $sql = "SELECT COUNT(autoid) FROM friend_blog_subscrib
                WHERE userid='" . $_SESSION['info']['auto_id'] . "'
                    AND subsuserid='$rowSelect[userid]'
                LIMIT 1";
    $result = executeQuery($sql);
    return mysql_result($result, 0) != 0;
} 
if(blog_is_subscribed()){
$notifications = 1;
} else {
$notifications = 2;
}
echo $notifications;

?>

[laserlight]

I agree with halojoy about error_reporting level, though I suggest setting it from php.ini on your development server (and having display_errors = On) instead of setting it at runtime with error_reporting().

[jasondavis]

thanks actually I just now set up a local server on my PC yesterday :x I been uploading files for testing for years, so much easiar now