Userlib - User Library

[eluser]Tom Schlick[/eluser]

Code:

function getData( $user, $what )
    {
        if(is_numeric($user))
        {
            $lcheck = $this->CI->db->query( "SELECT " . mysql_real_escape_string( $what ) . " FROM `user` WHERE
                                            ID='" . mysql_real_escape_string( $user ) . "'" );
            if( $lcheck->num_rows( ) == 1 )
            {
                $data = $lcheck->row( );
                return $data->$what;
            } else {
                return 'User or row does not exist.';
            }
        }
        else
        {
            $lcheck = $this->CI->db->query( "SELECT " . mysql_real_escape_string( $what ) . " FROM `users` WHERE
                                            username='" . mysql_real_escape_string( $user ) . "'" );
            if( $lcheck->num_rows( ) == 1 )
            {
                $data = $lcheck->row( );
                return $data->$what;
            } else {
                return 'Username or row does not exist.';
            }
        }
    }

i added the is_numeric to the get data so you will be able to put a user id number or just put in their username and both will work in the same function! (the only problem is that if their username is only numbers it will cause an error. so just make it so that your users have to include a letter in thier name)