ciao a tutti...sono nuovo di qui...ho letto le vostre guide...ed oltre ad essere PERFETTE sono anche semplici da capire!!!

ma veniamo al motivo vero per cui mi sono iscritto...sto realizzando un sitarello e mi serve inserire dei dati presi da un form in un DB mysql con il php...

purtroppo però mi ritorna un errore alla riga INSERT INTO....

vi posto il codice...

questo è quello del form...


<?php

echo "<form method=\"post\" action=\"eseguito.php\">";
echo "

Total Flight Number:";
echo "<input name=\"TotalFlightNumber\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Company ICAO:";
echo "<input name=\"CompanyICAO\" type=\"text\" size=\"5\" value=\"VIA\">";
echo "</p>";

echo "

Flight number:";
echo "<input name=\"FlightNumber\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Pilot Number:";
echo "<input name=\"PilotNumber\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Date:";
echo "<input name=\"Date\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Hour:";
echo "<input name=\"Hour\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Callsign:";
echo "<input name=\"Callsign\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

IATA Number:";
echo "<input name=\"IATANumber\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Registration:";
echo "<input name=\"Registration\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Depart:";
echo "<input name=\"Depart\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Arrival:";
echo "<input name=\"Arrival\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Plane Type:";
echo "<input name=\"PlaneType\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Spent fuel:";
echo "<input name=\"SpentFuel\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Init Fuel:";
echo "<input name=\"InitFuel\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

End Fuel:";
echo "<input name=\"EndFuel\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Duration:";
echo "<input name=\"Duration\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Lenght:";
echo "<input name=\"Length\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

TouchDownVerticalSpeed:";
echo "<input name=\"ToutchDownVerticalSpeed\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

TouchDownSpeed:";
echo "<input name=\"ToutchDownSpeed\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

TakeOffWeight:";
echo "<input name=\"TakeOffWeight\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Flighting Level:";
echo "<input name=\"FlightingLevel\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Route:";
echo "<input name=\"Route\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

Log:";
echo "<input name=\"Log\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

VSup:";
echo "<input name=\"VSup\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

VSdn:";
echo "<input name=\"VSdn\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

IASCruise:";
echo "<input name=\"IASCruise\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

FuelFlowTOC:";
echo "<input name=\"FuelFlowTOC\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

FuelFlowCruise:";
echo "<input name=\"FuelFlowCruise\" type=\"text\" size=\"5\">";
echo "</p>";

echo "

FuelFlowTOD:";
echo "<input name=\"FuelFlowTOD\" type=\"text\" size=\"5\">";
echo "</p>";


echo "

OnLine:";
echo "<input name=\"OnLine\" type=\"text\" size=\"5\">";
echo "</p>";


echo "

";
echo "<input type=\"submit\" value=\"Invia\">";
echo "</p>";
echo "</form>";


?>


----------------questo quello dell'invio dei dati....

<?php
include("config.inc.php");
$db = mysql_connect($db_host, $db_user, $db_password);
if ($db == FALSE) die ("Errore nella connessione. Verificare i parametri nel file config.inc.php");

mysql_select_db($db_name, $db)
or die ("Errore nella selezione del database. Verificare i parametri nel file config.inc.php");

$TotalFlightNumber=$_POST['TotalFlightNumber'];
$CompanyICAO=$_POST['CompanyICAO'];
$FlightNumber=$_POST['FlightNumber'];
$PilotNumber=$_POST['PilotNumber'];
$Date=$_POST['Date'];
$Hour=$_POST['Hour'];
$Callsign=$_POST['Callsign'];
$IATANumber=$_POST['IATANumber'];
$Registration=$_POST['Registration'];
$Depart=$_POST['Depart'];
$Arrival=$_POST['Arrival'];
$PlaneType=$_POST['PlaneType'];
$SpentFuel=$_POST['SpentFuel'];
$InitFuel=$_POST['InitFuel'];
$EndFuel=$_POST['EndFuel'];
$Duration=$_POST['Duration'];
$Length=$_POST['Length'];
$ToutchDownVerticalSpeed=$_POST['ToutchDownVerticalSpeed'];
$ToutchDownSpeed=$_POST['ToutchDownSpeed'];
$TakeOffWeight=$_POST['TakeOffWeight'];
$FlightingLevel=$_POST['FlightingLevel'];
$Route=$_POST['Route'];
$Log=$_POST['Log'];
$VSup=$_POST['VSup'];
$VSdn=$_POST['VSdn'];
$IASCruise=$_POST['IASCruise'];
$FuelFlowTOC=$_POST['FuelFlowTOC'];
$FuelFlowCruise=$_POST['FuelFlowCruise'];
$FuelFlowTOD=$_POST['FuelFlowTOD'];
$OnLine=$_POST['OnLine'];


INSERT INTO FSacarsOL (`TotalFlightNumber` , `CompanyICAO` , `FlightNumber` , `PilotNumber` , `Date` , `Hour` , `Callsign` , `IATANumber` , `Registration` , `Depart` , `Arrival` , `PlaneType` , `SpentFuel` , `InitFuel` , `EndFuel` , `Duration` , `Length` , `ToutchDownVerticalSpeed` , `ToutchDownSpeed` , `TakeOffWeight` , `FlightLevel` , `Route` , `Log` , `VSUp` , `VSDn` , `IASCruise` , `FuelFlowTOC` , `FuelFlowCruise` , `FuelFlowTOD` , `Online`)
VALUES('$TotalFlightNumber','$CompanyICAO','$Fligh tNumber','$PilotNumber','$Date','$Hour','$Callsign ','$IATANumber','$Registration','$Depart','$Arriva l','$PlaneType','$SpentFuel','$InitFuel','$EndFuel ','$Duration','$Length','$ToutchDownVerticalSpeed' ,'$ToutchDownSpeed','$TakeOffWeight','$FlightingLe vel','$Route','$Log','$VSup','$VSdn','$IASCruise', '$FuelFlowTOC','$FuelFlowCruise','$FuelFlowTOD','$ OnLine')


mysql_close($db);
?>



Confido in voi...perchè io non so piu cosa guardare!!!

ciao e grazie mille a tutti in anticipo!

Massimo