[Kane]

Your query is fine. I wrote out an example for you:

PHP код:

stock SQL(playerid){
    
    new 
        query[200]; 
        
    mysql_format(MySQL, query, sizeof query, "SELECT * FROM accounts WHERE IP = '%e'", 127.0.0.1); 
    mysql_tquery(MySQL, query, "IPAddressQuery", "i", playerid);
    return 1;
} 


Using the '%e' specifier escapes special characters in a string for the use in a SQL statement. It prevents backslashes to the following characters: \x00, \n, \r, \, ', " and \x1a.

PHP код:

IPAddressQuery(playerid); public IPAddressQuery(playerid)
{
    if (!cache_num_rows())
        return print("Accounts with that IP Address were not found.");
        
    new 
        rString[128], rName[32]
    ; 
    
    for(new i; i < cache_num_rows(); i++){
        cache_get_value(i, "Name", rName);
        
        format (rString, sizeof rString, "Found '%s' with the IP address specified.", rName); 
        SendClientMessage(playerid, -1, rString);
    }
        
    return 1;
} 


cache_num_rows() returns the number of rows found in the query.

We loop through the rows in the instance there are more than one account associated with the IP.