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:
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean 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