View Single Post
  #15  
Old 04-04-2012, 01:30 PM
_79_dev _79_dev is offline
Approved Member
 
Join Date: Sep 2010
Location: Dublin
Posts: 242
Default

still can`t get throuh cookies autorisation, IP is set and admins and users exist in database so it must be something on my side....


after adding pilot into squadron got error message:
PHP Code:
Warningmysqli_free_result() expects parameter 1 to be mysqli_resultboolean given in C:\xampp\htdocs\ClodStats\squadPilot.php on line 62 
thats part of code for file, last line is 62
PHP Code:
 // Get Pilot ID
    
$sql "SELECT pilotID
              FROM pilots
             WHERE pilotName = '"
.$pilotName."' COLLATE utf8_bin";

    
$getResults mysqli_query($mysqliAdmin$sql) or die(mysqli_error($mysqliAdmin));
    if (
mysqli_num_rows($getResults) > 0)
    {
       while (
$row = @mysqli_fetch_array($getResults))
       {
        
$pilotID stripslashes($row["pilotID"]);
       }
        
mysqli_free_result($getResults);

        
$sql "UPDATE pilots
                   SET squadronID = 
$squadronID
                 WHERE pilotID= 
$pilotID";

        
$getResults mysqli_query($mysqliAdmin$sql) or die(mysqli_error($mysqliAdmin));
         
mysqli_free_result($getResults); 
and if I edit last line like that

mysqli_free_result($getResults)or die (mysql_error());

it disconnect from database...
__________________

Asus P6T V2 Deluxe, I7 930, 3x2 GB RAM XMS3 Corsair1333 Mhz, Nvidia Leadtek GTX 470, Acer 1260p screen projector, Track IR 4 OS ver5, Saitek Pro Flight Rudder, Saitek X52, Win 7 x64 ultimate

Last edited by _79_dev; 04-04-2012 at 01:57 PM.
Reply With Quote