Hey everybody,

Can anybody see what is wrong here? I can't get any error messages to get a clue where to start. The "new part" is the function select_result(). Can you not pass back a result? Why don't I get at least some error message? I don't even see Hello World (HTML at the bottom). Very frustrating indeed.

Thanks,

Trey

<?
require_once("/home/mysite/db/dbDefinitions.inc"); // ;)

 function db_connect()
    {
    global $db_host, $db_user, $db_pwd, $db_name;
    $link_id = mysql_connect($db_host,$db_user,$db_pwd);
    mysql_select_db($db_name,$link_id);
    return $link_id;
    }

 function select_result($strSQL){
    $link = db_connect();
    $result = mysql_query($strSQL, $link);
    return $result;
    }

 function UID_inuse($uid){
    $result = select_result("SELECT COUNT(*) AS count FROM parent WHERE user_name='$uid'");
    $fetch = mysql_fetch_array($result,$link);
    return ($fetch['count'] == 0)?false:true;;
    }

if(UID_inuse("treyc"){
    echo "User ID is in use";
    }
else{
    echo "User ID not in use";
    }

?>
Hello world

---------------
Trey Carroll

Try adding "or die(mysql_error);" after every mysql function.

Also I noticed function UID_inuse has two ";" in a row...

Also I've heard its more reliable to open PHP with <?php and not <? but I don't remember where (or maybe it was about an older version...)

HTH,

----------
---Snib---
----------

<><

I figured it out. I haven't touched php in months and so I'm rusty. Seems like my Host had completely turned off error reporting in php.ini so I wasn't getting any clues. There are several dumb errors. You CAN return a result set from a function. Thanks for the help.



---------------
Trey Carroll