I am having trouble getting mysql table to update with new values. Via echo statement I am sure that each var below has a value. And I have double checked that each variable matches a column in my table.
I am getting output "Error, record update failed"
Novice user so please make any expination simplified. Thanks in advance.
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to selectdatabase $DBName");
$sqlquery = "UPDATE $table SET id='$id',count='$count',date='$date',paid_amount='$paid_amount',paid_date='$paid_date',ip='$ip',street1='$street1',city1='$city1',State='$State',maplink='$maplink',
rent='$rent',deposit='$deposit',arch='$arch',available='$available',month='$month',lease_len='$lease_len',lease_term='$lease_term',lease_type='$lease_type',
bed='$bed',bath='$bath',footage='$footage',school='$school',phone='$phone',name='$name',email='$email',company_name='$company_name',name_include='$name_include',
contact='$contact',url1='$url1',urlname1='$urlname1',url2='$url2',urlname2='$urlname2',url3='$url3',urlname3='$urlname3',url4='$url4',
urlname4='$urlname4',url5='$url5',urlname5='$urlname5',f1='$f1',f2='$f2',f3='$f3',f4='$f4',f5='$f5',f6='$f6',f7='$f7',f8='$f8',f9='$f9',
f10='$f10',f11='$f11',f12='$f12',f13='$f13',f14='$f14',f15='$f15',f16='$f16',f17='$f17',f18='$f18',f19='$f19',f20='$f20',f21='$f21',
el='$e1',e2='$e2',e3='$e3',e4='$e4',e5='$e5',e6='$e6',e7='$e7',e8='$e8',e9='$e9',el0='$e10',el1='$e11',el2='$e12',el3='$e13',el4='$e14',el5='$e15',
el6='$e16',el7='$e17',el8='$e18',el9='$e19',e20='$e20',e21='$e21',e22='$e22',e23='$e23',e24='$e24',nl='$n1',n2='$n2',n3='$n3',n4='$n4',
n5='$n5',n6='$n6',n7='$n7',n8='$n8',n9='$n9',nl0='$n10',nl1='$n11',nl2='$n12',cl='$c1',c2='$c2',c3='$c3',c4='$c4',c5='$c5',c6='$c6',
freeform='$freeform',hear='$hear' WHERE id='$id'";
mysql_query($query) or die('Error, record update failed');
$results = mysql_query($sqlquery);
mysql_close();
