Hey guys it's me again...
When I am trying to run one of my pieces of code I get the messege "Column count doesn't match value count at row 1." I spent hours on this one and I still cant figure it out. Please forgive my code it is rather long.
I posted the wrong code the first time... here is the correct code.
<html>
<head>
</head>
<body>
<?php
// set up some variables
// server name
$server = "localhost";
// username
$user = "vminter_admin";
// password
$pass = "12041980";
// open a connection to the database
$connection = mysql_connect($server, $user, $pass);
mysql_select_db("vminter_cars", $connection);
// formulate the SQL query - same as above
$qry = "INSERT INTO credit
(date,
myear,
make,
model,
newused,
mileage,
contact,
csp,
dpayment,
ntrade,
famount,
term,
aname,
ssn,
dob,
caddress,
city,
state,
zip,
yaddress,
hphone,
opro,
lmholder,
mra,
paddress,
pcity,
pstate,
pzip,
ypaddress,
naemployer,
ser,
aincome,
taj,
bphone,
position,
oincome,
soi,
csbn,
ba,
an,
bcsbn,
ban,
cdpn,
lafb,
balance,
ti,
creditcard,
ccother,
narnlwy,
rphone,
naf,
fphone,
nacr,
ra,
coaname,
cossn,
codob,
cocaddress,
cocity,
costate,
cozip,
coyaddress,
cohphone,
coopro,
colmholder,
comra,
copaddress,
copcity,
copstate,
copzip,
coypaddress,
conaemployer,
coser,
coaincome,
cotaj,
cobphone,
coposition,
cooincome,
cosoi,
acdn,
iswn,
hye)
VALUES
('$date',
'$myear',
'$make',
'$model',
'$newused',
'$mileage',
'$contact',
'$csp',
'$dpayment',
'$ntrade',
'$famount',
'$term',
'$aname',
'$ssn',
'$dob',
'$caddress',
'$city',
'$state',
'$zip',
'$yaddress',
'$hphone',
'$opro',
'$lmholder',
'$mra',
'$paddress',
'$pcity',
'$pstate',
'$pzip',
'$ypaddress',
'$naemployer',
'$ser',
'$aincome',
'$taj',
'$bphone',
'$position',
'$oincome',
'$soi',
'$csbn',
'$ba',
'$an',
'$bcsbn',
'$ban',
'$cdpn',
'$lafb',
'$balance',
'$ti',
'$creditcard',
'$ccother',
'$narnlwy',
'$rphone',
'$naf',
'$fphone',
'$nacr',
'$ra',
'$coaname',
'$cossn',
'$codob',
'$cocaddress',
'$cocity',
'$costate',
'$cozip',
'$coyaddress',
'$cohphone',
'$coopro',
'$colmholder',
'$comra',
'$copaddress',
'$copcity',
'$copstate',
'$copzip',
'$coypaddress',
'$conaemployer',
'$coser',
'$coaincome',
'$cotaj',
'$cobphone'
'$coposition',
'$cooincome',
'$cosoi'
'$acdn'
'$iswn'
'$hye')";
// run the query on the database
$result =mysql_query($qry) or die (mysql_error());
echo "<br><br><center><strong>Thank you for compleating the online credit application, a member of our traind staff will contact you when the application is processed.</strong></center>";
mail ("nova3211@comcast.net", "testing", "A new credit application for $aname has been submitted for apprpval", "From: TheDatabaseGod@InTheSky.com");
?>
</body>
</html>
