Here goes,
There are 2 scripts, the first one contains the code to display the form:
<?
function show_form(){
echo"<html>
<head>
<script>
function checkrequired(which){
var pass=true
if (document.images){
for (i=0;i<which.length;i++){
var tempobj=which.elements[i]
if (((tempobj.type=='text'||tempobj.type=='password')&&tempobj.value=='')||(tempobj.type.toString().charAt(0)=='s'&&tempobj.selectedIndex==-1)){
pass=false
break
}
}
}
if (!pass){
alert('You have not completed all the required information.\\r\\nPlease complete your entry and then re-submit.')
return false
}
else
return true
}
</script>
</Head>
<title>Welcome! Enter your registration details.</title>
<font face='Arial' size='2'>
<h3><b>Enter your company information.<b></h3>
<body>
<form method='post'action=check.php onSubmit='return checkrequired(this)' name=test>
<table width='50%' border='0' cellspacing='0' cellpadding='0'>
<div align='left'><font face='Arial' size='2'>
<tr><td>Company Name:</td> <td>
<input type='text' name='company' size=35 value='$test'><br></td></tr>
<tr><td>Address:</td> <td>
<input type='text' name='address' size=35><br></td></tr>
<tr><td></td><td>
<input type'text' name='address2' size=35><br></td></tr>
<tr><td>County:</td> <td>
<select name=county>
<option value=Aberdeenshire>Aberdeenshire</option><option value=Anglesey>Anglesey</option><option value=Angus>Angus</option>
<option value=Argyllshire>Argyllshire</option><option value=Avon>Avon</option><option value=Ayrshire>Ayrshire</option>
<option value=Banffshire>Banffshire</option><option value=Bedfordshire>Bedfordshire</option><option value=Berkshire>Berkshire</option>
<option value=Berwickshire>Berwickshire</option><option value=Breconshire>Breconshire</option><option value=Buckinghamshire>Buckinghamshire</option>
<option value=Buteshire>Buteshire</option><option value=Caernarvonshire>Caernarvonshire</option><option value=Cambridgeshire>Cambridgeshire</option>
<option value=Cardiganshire>Cardiganshire</option><option value=Carmarthenshire>Carmarthenshire</option><option value=Cheshire>Cheshire</option>
<option value=Clackmannanshire>Clackmannanshire</option><option value=Cleveland>Cleveland</option><option value=Cornwall>Cornwall</option>
<option value=Cumbria>Cumbria</option><option value=Denbighshire>Denbighshire</option><option value=Derbyshire>Derbyshire</option>
<option value=Devon>Devon</option><option value=Dorset>Dorset</option><option value=Durham>Durham</option>
<option value=East Sussex>East Sussex</option><option value=Essex>Essex</option><option value=Fifeshire>Fifeshire</option>
<option value=Flintshire>Flintshire</option><option value=Glamorganshire>Glamorganshire</option><option value=Gloucestershire>Gloucestershire</option>
<option value=Hampshire>Hampshire</option><option value=Herefordshire>Herefordshire</option><option value=Hertfordshire>Hertfordshire</option>
<option value=Humbershire>Humbershire</option><option value=Inverness-shire>Inverness-shire</option><option value=Isle Of Man>Isle Of Man</option>
<option value=Kent>Kent</option><option value=Kincardine>Kincardine</option><option value=Kinross>Kinross</option><option value=Kirkcudbrightshire>Kirkcudbrightshire</option>
<option value=Lanarkshire>Lanarkshire</option><option value=Lancashire>Lancashire</option><option value=Leicestershire>Leicestershire</option>
<option value=Lincolnshire>Lincolnshire</option><option value=Manchester>Manchester</option><option value=Merionethshire>Merionethshire</option>
<option value=Merseyside>Merseyside</option><option value=Middlesex>Middlesex</option><option value=Midlands>Midlands</option>
<option value=Midlothian>Midlothian</option><option value=Montgomeryshire>Montgomeryshire</option><option value=Morayshire>Morayshire</option>
<option value=Norfolk>Norfolk</option><option value=North Yorkshire>North Yorkshire</option><option value=Northamptonshire>Northamptonshire</option>
<option value=Northumberland>Northumberland</option><option value=Nottinghamshire>Nottinghamshire</option><option value=Orkney Islands>Orkney Islands</option>
<option value=Oxfordshire>Oxfordshire</option><option value=Peeblesshire>Peeblesshire</option><option value=Pembrokeshire>Pembrokeshire</option>
<option value=Perthshire>Perthshire</option><option value=Radnorshire>Radnorshire</option><option value=Renfrewshire>Renfrewshire</option>
<option value=Ross and Cromarty>Ross and Cromarty</option><option value=Roxburghshire>Roxburghshire</option><option value=Selkirkshire>Selkirkshire</option>
<option value=Shetland Islands>Shetland Islands</option><option value=Shropshire>Shropshire</option><option value=Somerset>Somerset</option>
<option value=South Yorkshire>South Yorkshire</option><option value=Staffordshire>Staffordshire</option><option value=Stirlingshire>Stirlingshire</option>
<option value=Suffolk>Suffolk</option><option value=Surrey>Surrey</option><option value=Sussex>Sussex</option>
<option value=Sutherlandshire>Sutherlandshire</option><option value=Tyne & Wear>Tyne & Wear</option><option value=Warwickshire>Warwickshire</option>
<option value=West Lothian>West Lothian</option><option value=West Sussex>West Sussex</option><option value=West Yorkshire>West Yorkshire</option>
<option value=West Midlands>West Midlands</option><option value=Wigtownshire>Wigtownshire</option><option value=Wiltshire>Wiltshire</option>
<option value=Worcestershire>Worcestershire</option><option value=Yorkshire>Yorkshire</option>
</tr>
<tr><td>Post Code:</td> <td>
<input type='text' name='postcode' size=9><br></td></tr>
<tr><td>Phone No.:</td> <td>
<input type='text' name='tel' size=15><br></td></tr>
<tr><td>Fax No.:</td> <td>
<input type='text' name='fax' size=15><br></td></tr>
<tr><td>Web Site:</td> <td>
<input type='text' name='web' size=25><br></td></tr>
</table>
<hr>
<font size='4'><b>Enter your contact information.</b></font>
<table width='50%' border='0' cellspacing='0' cellpadding='0'>
<div align='left'><font face='Arial' size='2'>
<tr><td>First Name: </td> <td><input type='text' name='first' size=19><br></td></tr>
<tr><td>Surname: </td> <td><input type='text' name='surname' size=19><br></td></tr>
<tr><td>Position: </td> <td><input type='text' name='position' size=20><br></td></tr>
<tr><td>Phone No.: </td> <td><input type='text' name='phone' size=15><br></td></tr>
<tr><td>Email: </td> <td><input type='text' name='email' size=25><br></td></tr><br>
</table>
<hr>
<table width='31.5%' border='0' cellspacing='0' cellpadding='0'>
<div align='left'><font face='Arial' size='2'>
<tr><td>User Name: </td> <td><input type='text' name='user' size=19 value=$pass><br></td></tr>
<tr><td>Password: </td> <td><input type='password' name='pass' size=19><br></td></tr>
<tr><td>Confirm Password: </td> <td><input type='password' name='passconf' size=19><br></td></tr><br>
</table><hr>
<input type='Submit' value='Submit'>
<input type='Reset' style='margin-left:14.0pt'>
</form>
</body>
</html>";
}?>
The second page is the once that queries a db and should insert values:-
<?
session_start();
if (!session_is_registered("SESSION"))
{
header("Location: /error.php");
exit();
}
$user=$HTTP_SESSION_VARS['SESSION_UNAME']; //define the username from the session name.
$connection=mysql_connect('localhost','root');//connect to the database
mysql_select_db('reseller');//select the database to use
$userdata=mysql_fetch_assoc(mysql_query("select * from user where user ='$user'")); //select the user details from db.
$pass=$userdata['pass'];
$email=$userdata['email'];
$company=$userdata['company'];
$contactdata=mysql_fetch_assoc(mysql_query("select * from contact where email ='$email'"));
$first=$contactdata['first'];
$surname=$contactdata['surname'];
$position=$contactdata['position'];
$phone=$contactdata['phone'];
$companydata=mysql_fetch_assoc(mysql_query("select * from company where company='$company'"));
$address=$companydata['address'];
$address2=$companydata['address2'];
$county=$companydata['county'];
$postcode=$companydata['postcode'];
$tel=$companydata['tel'];
$fax=$companydata['fax'];
$web=$companydata['web'];
require("signup.php");
show_form($pass);
?>
Any help is appreciated, I can't make too many changes to the form, as it will also be used in the first instance as a signup form, and in this case it is being used again in case users need to change their inputted information.
Thanks.
MBK