Validation of Form data ** SOLVED **

Lieutenant Joined: Mar 10, 2005 Posts: 166

The code snippet here is the admin function that 'should' take the data from the form and insert the fields inputed into the database.

Problem is, it does not do that. It gives no error, it simply returns a blank screen, when it should read back the server details that have just been written to the database.

Anyone know what I did wrong here??

v7.9 PHP-Nuke (patched) v5 PHP & MySQL

Code:

global $sid, $uid, $host, $port, $spasswd, $vpasswd, $sname, $vname, $auth, $modneedpw, $clientcount, $maxclients, $platform, $version, $lastquery, $homepage, $colbg1, $colbg2, $colbg3, $coltxt1, $coltxt2, $dbname;

if ($modneedpw=='Yes') {
   $modneedpw='1';
   } else {
   $modneedpw='0';
   }

   $result = @mysql_db_query($dbname,"INSERT INTO ghq_jcsvt_server (sid, uid, host, port, spasswd, vpasswd, sname, vname, auth, modneedpw, clientcount, maxclients, platform, version, lastquery, homepage) VALUES ('$sid', '$uid', '$host', '$port', '$spasswd', '$vtpasswd', '$sname', '$vname', '$auth', '$modneedpw', '$clientcount', '$maxclients', '$platform', '$version', '$lastquery', '$homepage')");

   $newindex=mysql_insert_id();
   $address="admin.php?op=jcsvtserverdetail&evid=".$newindex;
   Header("Location: $address");

Note: I did not post the entire function, just the core code has been posted.

Site Admin Joined: Aug 17, 2003 Posts: 12383

Remove the @ symbol, that should give you the error message if you've enabled error reporting

Lieutenant Joined: Mar 10, 2005 Posts: 166

$display_errors = true; is set, although it does not display any errors. Matter of fact, that feature has never worked for me.

Site Admin Joined: Aug 17, 2003 Posts: 12383

Put the SQL query into a variable and echo that to your browser. Then run the query in phpMyAdmin to determine if there's an error in the query

Lieutenant Joined: Mar 10, 2005 Posts: 166

Thx for all, my coding partner solved this issue by implmenting a different set of queries to get things done.

Appreciate your time and effort.