MySQL Insert

[Anon]

I have the following PHP code:

// *** Insert form info into mysql
mysql_connect("hostname","username","password") or die ("Could Not Connect");
mysql_selectdb("hlc_amreg") or die("Unable to Select Database");

$query = "INSERT INTO Registration VALUES(NULL, '$NewAttendee', '$BadgeName', '$FirstName', '$MiddleName', '$LastName', 
         '$Title', '$Institution', '$Address', '$City', '$State', '$ZipCode', '$PhoneNumber', '$Extension', '$FaxNumber', '$Email', '$SpecialNeeds', 
		 '&SingleReg', '$GenProgOnly', '$OneDayFee', '$Exhibitor', '$FullConference', '$OneDayPass', '$WorkshopSS', '$SSCoord', 
		 '$SteeringComm', '$WorkshopAI', '$ProgPres', '$CEPDP', '$CurrentCE', '$CurrentTC', '$NewCE', '$NewTC', '$CombinedProg',
		 '$FSWorkshop', '$FSWorkshopFriMorn', '$FSWorkshopSunMorn', '$FTWorkshop', '$FTWorkshopFriAft', '$FTWorkshopTuesMorn', 
		 '$AllAQIPWS', '$AllAQIPFriMorn', '$AllAQIPSunMorn', '$AllAQIPFirAft', '$AllAQIPTuesMorn', '$CQC')";
$result = mysql_query($query);

// End of database INSERT

[Anon]

Sorry, hit Enter on accident. As I was saying my php code is not giving me an error but it is also NOT putting my data into the database. Any suggestions as you look at the code. Thanks in advance.

Jeremy

[herve]

Quite surely there's a Mysql error happening
to you should check the error message
(BTW, it's a good habit to always check for
errors even when "it can't fail" .. :-) ! )

$cmd="INSERT INTO models ....";
$result = mysql_query ($cmd,$db);

if (!$result)
{
print mysql_errno();
print mysql_error();
}

[[deleted]]

This is all very case sensitive, so check for case and also typos in field names both in your form and in the query.