Simple SQL Insert Query Won't Work!!
Posted: Tue May 13, 2003 4:54 pm
This won't put data in the StreetNum field. Every field has the data properly inserted excepted this field, and it's really boggling me.
$thirdquery = "INSERT INTO CustomerEntry (ClientSalesID, ClientNameID, FName, LName, StreetNum , StreetName, Zip, Telephone, Email, GuessNumber, GuessDate, CurrVehicleYr, CurrVehicleMake, CurrVehicleModel, LastVehiclePurchase, VehicleType, CurrPayement, MostImportantNewCar, Marketing) values ('$findtheidresult','$theclientid','$FName','$LName','$SteetNum','$StreetName','$Zip','$Telephone','$Email','$GuessNumber','$GuessDate','$CurrVehicleYr','$CurrVehicleMake','$CurrVehicleModel','$LastStringTotal','$VehicleType','$CurrPayment','$MostImportantNewCar','$Marketing') ";
mysql_query($thirdquery);
So since there was only one that didn't enter correctly, I thought maybe the variable '$StreetNum' was incorrect. Here's the input field:
<td> <input name="StreetNum" type="text" id="StreetNum" size="10" maxlength="10">
I'm not sure what's going on?? It is left blank, or NULL no matter what you enter in it.
$thirdquery = "INSERT INTO CustomerEntry (ClientSalesID, ClientNameID, FName, LName, StreetNum , StreetName, Zip, Telephone, Email, GuessNumber, GuessDate, CurrVehicleYr, CurrVehicleMake, CurrVehicleModel, LastVehiclePurchase, VehicleType, CurrPayement, MostImportantNewCar, Marketing) values ('$findtheidresult','$theclientid','$FName','$LName','$SteetNum','$StreetName','$Zip','$Telephone','$Email','$GuessNumber','$GuessDate','$CurrVehicleYr','$CurrVehicleMake','$CurrVehicleModel','$LastStringTotal','$VehicleType','$CurrPayment','$MostImportantNewCar','$Marketing') ";
mysql_query($thirdquery);
So since there was only one that didn't enter correctly, I thought maybe the variable '$StreetNum' was incorrect. Here's the input field:
<td> <input name="StreetNum" type="text" id="StreetNum" size="10" maxlength="10">
I'm not sure what's going on?? It is left blank, or NULL no matter what you enter in it.