This is the statement which is passed when no errors are found.
Code: Select all
$result=mysql_query("insert into ora_details (site_id, site_name, dba_subscriber, os_used, os_version, ora_version,
conn_type, server_ip, server_subnet, server_gateway, ora_port_no, db_name1, db_name2, server_use,
ras_user, ras_pass, ras_sp_det, ras_dial, direct_dial, pc_any_user, pc_any_pass, os_user, os_pass,
vpn_name, vpn_user, vpn_pass, vpn_det, web_url, add_det, timestamp)
values
('".$_GET['lea']."','".$_POST['sitename']."','".$_POST['dbasub']."','".$_POST['osused']."','".$_POST['osversion']."',
'".$_POST['oraver']."','".$_POST['conntype']."','".$_POST['serverip']."','".$_POST['serversub']."',
'".$_POST['servergate']."','".$_POST['oraportno']."','".$_POST['dbname1']."','".$_POST['dbname2']."',
'".$_POST['serveruse']."','".$_POST['rasuser']."','".$_POST['raspass']."','".$_POST['rasspdet']."','".$_POST['rasdial']."',
'".$_POST['directdial']."','".$_POST['pcanyuser']."','".$_POST['pcanypass']."','".$_POST['osuser']."',
'".$_POST['ospass']."','".$_POST['vpnname']."','".$_POST['vpnuser']."','".$_POST['vpnpass']."',
'".$_POST['vpndet']."','".$_POST['weburl']."','".$_POST['adddet']."', now())") or die(mysql_error());
As I said before, it inserts all the data, but puts the default value of 0 into the site_id column. I have tried this when the lea=1 in the url and it doesn't work, but when I replace the varibale in the insert with the number 1 it does work?
Any other ideas?