Php > Database Related

Single Query MySQL Functions

Single Query MySQL Functions

<? 
    /* 
    *    These functions provide a simple API for returning one set of results. 
    *    Syntax : 
    *    mysql_one_data($query); 
    *    mysql_one_array($query); 
    * 
    *    Example : 
    *    $fname = mysql_one_data("SELECT fname FROM users WHERE id = '2'"); 
    * 
    *    $user = mysql_one_array("SELECT * FROM users WHERE id = '2'"); 
    */ 

    /* 
    *    mysql_one_data([ string query ]); 
    */ 

    function mysql_one_data($stmt) { 
        $query=mysql_query($stmt); 
        $result=mysql_fetch_row($query); 
        return($result[0]); 
    } 

    /* 
    *    mysql_one_array([ string query ]); 
    */ 

    function mysql_one_array($stmt) { 
        $query=mysql_query($stmt); 
        $result=mysql_fetch_array($query); 
        return($result); 
    } 
?>