submit page is http://www.lifelinestaff.com/apply.htm
apply.php is as follow (HTML at end chopped)
<?php
$link = mysql_connect ("IPADDRESS","UNAME","PWORD");
mysql_select_db ("test");
Get post variables and place them in to local variables
#while (list($key, $value) = each
#(${"HTTP_POST_VARS"}))
#{
#echo $key." = ".$value." ";
#$$key = $key;
foreach($HTTP_POST_VARS as $key => $value)
{
$varname = $key;
$$varname = $value;
$querystringa .= $key . ",";
$querystringb .= "'$".$key . "',";
}
#}
Chop off Submit from end of strings
$querystringa = substr($querystringa,0,-8);
$querystringb = substr($querystringb,0,-11);
Concatenate keys and values in to statement
$queryfinal = "INSERT INTO appunqual " ;
$queryfinal .= "(";
$queryfinal .= $querystringa;
$queryfinal .= ")";
$queryfinal .= VALUES;
$queryfinal .= "(";
$queryfinal .= $querystringb;
$queryfinal .= ")";
$queryfinal .= ";";
PRINT "$queryfinal <br>$fname $lname<br> $query <br>";
mysql_error();
Make insert query
$query = mysql_query($queryfinal);
echo mysql_error($link);
?>
when i do my submit of data i get the following output from my debug lines i shoved in ... I am sure i am missing something small .. thanks in advance
OUTPUT from PRINT and ECHO
INSERT INTO appunqual (app_id,fname,lname,street1,street2,city,state,zip,homephone,cellphone,otherphone,email1,email2,travelnurse,prnstaffing,specotherdesc,certifications,contactby,comments)VALUES('$app_id','$fname','$lname','$street1','$street2','$city','$state','$zip','$homephone','$cellphone','$otherphone','$email1','$email2','$travelnurse','$prnstaffing','$specotherdesc','$certifications','$contactby','$comments');
sdfgsdfg sdfgsdfgsdfgdsfgdfg
Thanks
