mysql_fetch_object() error / no database selected

[moose4204l]

the error i got was
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in file.php

when i put the error echo in it i get the error no database selected.

this might have to do with querying my db through a function call. here are the two code snippets i believe to be the region of interest.

myFunctions.php

function subtractRecallPoint() {
        require_once( 'path/to/mysql_connect.php' );

     // get the amount of points from the db
     $query = "SELECT recallPoints from recallStatus WHERE rs_id =1";
     $result = mysql_query( $query ); //or die( " failed: " .mysql_error() );; 
                   //mysql_error() was producing the no database selected message
     $retrieved = mysql_fetch_object( $result );
     $rp = $retrieved->recallPoints;
    ...

viewEntries.php

require_once( 'path/to/mysql_connect.php' );// connect to the database

    if( isset($_POST['submitted']) ) {

            if( $_POST['q1'] == $_POST['num'] ) {

                    if( (checkChoice($_POST['d0'], $_POST['t0'])) && (checkChoice($_POST['d1'], $_POST['t1'])) && (checkChoice($_POST['d2'], $_POST['t2'])) && (checkChoice($
                            addRecallPoint();
                            myExit('good');
                    } else {
                            subtractRecallPoint();
                            myExit('failed checkChoices');
                    }
            } else {
                    myExit('failed num compare');
            }

    } else {
...

now i know these codes did run prior to putting in the function call of subtractRecallPoint(). the querying done in the method worked when i had it on an external form handling php page. I just started out with php/mysql. Any help?

[moose4204l]

i just gutted out the other two functions. Now it works to the extent of back on track. I guess it comes down to me asking for a little lesson. is it wrong to have a myfunctions.php file that reads

<?php

function myExit($s) {
        if( $s == 'good' ){
                echo 'nice';
                exit();
      }
        echo $s;
        exit();
}


function checkChoice($day, $time) {
        require_once( '/path/to/mysql_connect.php' );

    $query = "SELECT day, time FROM entries WHERE day = '$day' and time = '$time'";
    $result = mysql_query( $result );
    if( !$result ){  // didnt find the match
            mysql_close();
            myExit('failed in check choices myfunction.php');
    } else {
            mysql_close();
            return 1;
    }
}


function addRecallPoint() {
        require_once( 'path/to/mysql_connect.php' );

    // get the amount of points from the db
    $query = "SELECT recallPoints from recallStatus WHERE rs_id = 1";
    $result = mysql_query( $query );
    $retrieved = mysql_fetch_object( $result );
    $rp = $retrieved->recallPoints;

    // add 1 to the value
    $rp++;

    // update the db to reflect the amount
    $query = "UPDATE recallStatus SET recallPoints = '$rp'";
    $result = mysql_query( $query );
    if( $result ) {
            echo    '<h1 id="mainhead">Good Job!!!</h1>
 <p>You just added 1 point to your overall recall points</p>
                        <p>You are on your way to having better recall ability</p>
                        <br /><p>Your overall points now equal ' .$rp .'!</p>';
        } else {
                echo '<h1 id="error">NOPE SOMETHING WRONG WITH QUERY</h1>';
        }
        mysql_free( $result );
        mysql_close();
}


function subtractRecallPoint() {
        require_once( './path/to/mysql_connect.php' );

     // get the amount of points from the db
     $query = "SELECT recallPoints from recallStatus WHERE rs_id =1";
     $result = mysql_query( $query );
//or die( " failed: " .mysql_error() );;
         $retrieved = mysql_fetch_object( $result );
         $rp = $retrieved->recallPoints;

    // if $rp == 0 exit/put 0/ return/ ... else subtract 1
    if( $rp == 0 ) {
            echo    '<h1 id="error">Listen up!!</h1>
                    <p>Your points still equal 0. Please concentrate a little more before selecting to view entry.</p>
                    <p>Clear your mind and stretch your body. When you\'re ready, let\'s try again!!</p>';
                    myExit('rp = 0');
    } else {
            $rp--;
 // update the db to reflect the amount
                $query = "UPDATE recallStatus SET recallPoints = '$rp'";
                $result = mysql_query( $query );
                if( $result ) {
                        echo    '<h1 id="mainhead">NOOOOOOOOOOO!!!!</h1>
                                <p>I\'m terribly sorry, you just lost one point on your overall recall points</p>
                                <p>You need more practice. You should also try eating more cruciferous vegetables and greens</p>
                                <br /><p>Your overall points now equal ' . $rp .'!';

            } else {
                    echo '<h1 id="error">NOPE SOMETHING WRONG WITH QUERY</h1>';
            }
    }
    mysql_close();
}

disregard if some of my comparisons might not syntactically work because this is my learning process so to speak. I am more in need of help with understanding if mysql/php interactions are completely wrong or whatever. Thanks

[Weedpacket]

Apart from the chaotic indentation, and the ghastly effect of the "MyExit" function? Whether it's "wrong" or not depends on how your site is built. It's "wrong" if it doesn't fit with that structure.