Re: calling function from function?

I hate posting all of that code, but for Greg's question... it does give me the correct array data. Jason wrote:

Rick Fletcher wrote:

function db( $host, $user, $pass, $dbnam ) { $db = @mysql_pconnect( $host, $user, $pass )or die( mysql_error( $db ));

       @mysql_select_db( $dbnam )or die( mysql_error( $db ) );

return $db; } function logs() { global $defined; db( $defined[9], $defined[1], $defined[2], $defined[3] ); ... do some processing ... } what am i missing here? i get errors if i try to pass $db to logs. i.e. logs( $db );

What's missing? The error message. Include it, and the offending line(s) of code, and ask again. --Rick

There isnt an error at all. According to the die() functions at the end of the mysql() functions it should give it there, instead I get blank as if the function has not successfully completed. The reason I say this is if you try to access the mysql resource pointer ( $db, in this case ) I get nothing, a return code of 0. Example in point... function db( $host, $user, $pass, $dbnam ) { $db = @mysql_pconnect( $host, $user, $pass )or die( "<font face=\"arial\"><b>phpDHCPAdmin currently not active, is under repair or is not configured correctly.</b><br><br>Error Number: " . mysql_errno( $db ) . "<br>Error Message: " . mysql_error( $db ) . "<br>Email Administrator: <a href=\"mailto:$defined[5]\">$defined[5]</a></font>" );

       @mysql_select_db( $dbnam )or die( "<font face=\"arial\"><b>Could not connect to database: $defined[3]</b><br>Error Message: " . @mysql_error( $db ) . "<br>" . "Error Number: " . @mysql_errno( $db ) . "<br>Email Administrator: <a href=\"mailto:$defined[5]\">$defined[5]</a></font>" );

return $db; } function logs() { global $defined; db( $defined[9], $defined[1], $defined[2], $defined[3] ); $pagecount = "1"; $tble = "logs"; $sql = @mysql_query( "SELECT * FROM $tble WHERE session = \"$_SESSION[hash]\"", $db )or die( "<font face=\"arial\"><b>Error occured when searching logs for session id:</b> $_SESSION[hash]<br>Error Message: " . @mysql_error( $db ) . "<br>" . "Error Number: " . @mysql_errno( $db ) . "<br>Email Administrator: <a href=\"mailto:$defined[5]\">$defined[5]</a></font>" ); while( $row = @mysql_fetch_array( $sql ) ) { $id = $row["session"]; }

    if( @mysql_num_rows( $sql ) == 0 ) {
     $insert = @mysql_query( "INSERT INTO $tble VALUES (\"\",\"$_SESSION[date]\",\"$_SESSION[hour]\",\"$_SESSION[ipaddy]\",\"$_SESSION[host]\",\"$_SESSION[ref]\",\"$_SERVER[HTTP_USER_AGENT]\",\"$_SERVER[PHP_SELF]\",\"$pagecount\",\"$_SESSION[msg]\",\"$_SESSION[hash]\")", $db )or die( "<font face=\"arial\"><b>Error occured creating logs for $_SESSION[hash]</b><br>Error Message: " . @mysql_error( $db ) . "<br>" . "Error Number: " . @mysql_errno( $db ) . "<br>Email Administrator: <a href=\"mailto:$defined[5]\">$defined[5]</a></font>" );
    } elseif( @mysql_num_rows( $sql ) != 0 ) {
     if( ( $_SESSION['hash'] == $id ) || ( empty( $pagecount ) ) ) {
      $pagecount++;
      $update = @mysql_query( "UPDATE $tble SET date=\"$_SESSION[date]\", time=\"$_SESSION[hour]\", ip=\"$_SESSION[ipaddy]\", host=\"$_SESSION[host]\", referer=\"$_SESSION[ref]\", agent=\"$_SERVER[HTTP_USER_AGENT]\", page=CONCAT(page,\".:||:.$_SERVER[PHP_SELF]\"), pagecount=\"$pagecount\", message=\"$_SESSION[msg]\", session=\"$_SESSION[hash]\" WHERE session=\"$id\"", $db )or die( "<font face=\"arial\"><b>Error occured while updating logs for $_SESSION[hash]</b><br>Error Message: " . @mysql_error( $db ) . "<br>" . "Error Number: " . @mysql_errno( $db ) . "<br>Email Administrator: <a href=\"mailto:$defined[5]\">$defined[5]</a></font>" );
     } else {
      call_user_func( "exit_app" );
     }
    } else {
     call_user_func( "exit_app" );
    }

} when called with logs(); returns this: Error occured when searching logs for session id: 82a831c4190f6e929032c0a9512c3657 Error Message: Error Number: Email Administrator: jason.gerfen@scl.utah.edu

-- Jason Gerfen Student Computing Marriott Library 801.585.9810 jason.gerfen@scl.utah.edu "And remember... If the ladies don't find you handsome, they should at least find you handy..." ~The Red Green show