ok sorry about that..i forgot about the username and password...
the code is the following...i'll include the config.inc code in the next posting...all the php code is in bold..
the javascript is commented to understand...basically for rollovers and for a random fact link on the page...
<?include "config.inc";?>
<html>
<head>
<title>Philips Lighting - Link to Us</title>
<script language="JavaScript" type="text/javascript">
<!--
if (document.images) {
IMG1_hiLite = new Image(60,21);
IMG1_hiLite.src = "/images/gh02h.jpg";
IMG1_normal = new Image(60,21);
IMG1_normal.src = "/images/gh02.jpg";
IMG2_hiLite = new Image(60,21);
IMG2_hiLite.src = "/images/gh03h.jpg";
IMG2_normal = new Image(60,21);
IMG2_normal.src = "/images/gh03.jpg";
IMG3_hiLite = new Image(60,21);
IMG3_hiLite.src = "/images/gh04h.jpg";
IMG3_normal = new Image(60,21);
IMG3_normal.src = "/images/gh04.jpg";
IMG4_hiLite = new Image(60,21);
IMG4_hiLite.src = "/images/i_b1b.gif";
IMG4_normal = new Image(60,21);
IMG4_normal.src = "/images/i_b1.gif";
IMG5_hiLite = new Image(60,21);
IMG5_hiLite.src = "/images/i_b3b.gif";
IMG5_normal = new Image(60,21);
IMG5_normal.src = "/images/i_b3.gif";
IMG6_hiLite = new Image(60,21);
IMG6_hiLite.src = "/images/i_b2b.gif";
IMG6_normal = new Image(60,21);
IMG6_normal.src = "/images/i_b2.gif";
IMG7_hiLite = new Image(60,21);
IMG7_hiLite.src = "/images/i_b4b.gif";
IMG7_normal = new Image(60,21);
IMG7_normal.src = "/images/i_b4.gif";
IMG8_hiLite = new Image(60,21);
IMG8_hiLite.src = "/images/i_b5b.gif";
IMG8_normal = new Image(60,21);
IMG8_normal.src = "/images/i_b5.gif";
IMG9_hiLite = new Image(60,21);
IMG9_hiLite.src = "/images/i_b6b.gif";
IMG9_normal = new Image(60,21);
IMG9_normal.src = "/images/i_b6.gif";
IMG10_hiLite = new Image(60,21);
IMG10_hiLite.src = "/images/i_b7b.gif";
IMG10_normal = new Image(60,21);
IMG10_normal.src = "/images/i_b7.gif";
//BOTTOM OF COLUMN
//IMG_BOTTOM = new Image(118,39);
//IMG_BOTTOM.src = "/images/i_b8.gif";
}
function hiLiteImage(normal, hiLite) {
if(document.images) {
document.images[normal].src = eval(hiLite + ".src"

;
//if (doRollOver == 1) document.images[normal].src = eval
(hiLite + ".src"

;
}
return;
}
// FACTS OF LIGHT
var MaxFacts = 17;
function loadFact() {
if(Math.random && Math.round) {
FactNum = Math.random()* MaxFacts;
thisFactNum = Math.round(FactNum) + 1
FactWindow = window.open("/facts/" + thisFactNum +
".htm","definition","toolbar=no,loc
ation=no,directories=no,status=yes,menubar=no,scrollbars=yes
,resizable=no,copyhistory=no,width=275,height=220"

if(FactWindow.creator) {
FactWindow.creator = self;
}
if(window.FactWindow.focus) {
window.FactWindow.focus();
}
}
else {
if(Date && Math.round) {
Today = new Date();
PseudoRandomNumber = Math.round(((Today.getSeconds
()/59)*MaxFacts)%MaxFacts)
FactWindow = window.open("/facts/" +
PseudoRandomNumber
+".htm","definition","toolbar=no,lo
cation=no,directories=no,status=yes,menubar=no,scrollbars=ye
s,resizable=no,copyhistory=no,width=275,height=220"
if(FactWindow.creator) {
FactWindow.creator = self;
}
}
else {
FactWindow = window.open("/facts/1.htm","definition","toolb
ar=no,location=no,directories=no,status=yes,menubar=no,scrol
lbars=yes,resizable=no,copyhistory=no,width=275,height=220&q
uot
if(FactWindow.creator) {
FactWindow.creator = self;
}
}
}
}
// -->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#FF0000" alink="#FF0000">
//<?include "headfoot/mail_header_2.htm"?>
<table border="0" width="600" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="482" bgcolor="#FFCC00"><font color="#000000" face="Arial, Helvetica"> <b>Join our Mailing List</b></font></td>
<td valign="top"><img src="/images/sub3_6a.jpg"></td>
</tr>
<tr>
<td></td>
<td valign="top"><img src="/images/sub3_6b.jpg"></td>
</tr>
</table>
<?
function register_email() {
global $fname, $lname, $email, $country, $occupation,
$feature_stories, $email_ok, $how_to_light, $site_news;
?>
<table border="0" width="600" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" colspan="3" width="600"><tr>
</tr>
<tr>
<td valign="top" colspan="2" width="150"><br><br>
<form method="post" action="thankyou.php">
<input type="hidden" name="action" value="register">
<div align="center">
<table border="2" cellpadding="5" cellspacing="0" width=600>
<tr>
<td valign="top"><font face="arial, helvetica, sans-
serif" size="3">Join the Philips Light Site mail list. This
confidential information will be used by us solely to keep
you informed about Philips and The Light Site.</font></td>
</tr>
<tr>
<td valign="top">
<table border="0">
<tr>
<td><font face="arial, helvetica, sans-serif"
size="2">First Name</font><br>
<input type="text" size="20" name="fname"></td>
<td><font face="arial, helvetica, sans-serif"
size="2">Last Name</font><br>
<input type="text" size="20" name="lname"></td>
</tr>
<tr>
<td><font face="arial, helvetica, sans-serif"
size="2">Email Address</font><br>
<input type="text" size="20" name="email"></td>
<td><font face="arial, helvetica, sans-serif"
size="2">Country</font><br>
<select name="country" size="1">
<option>Select Country</option>
<option value="Argentina">Argentina</option>
<option value="Australia">Australia</option>
<option value="Austria">Austria</option>
<option value="Bolivia">Bolivia</option>
<option value="Brazil">Brazil</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Colombia">Colombia</option>
<option value="CostaRica">Costa Rica</option>
<option value="Czech">Cz Rep.</option>
<option value="Ecuador">Ecuador</option>
<option value="Salvador">El Salvador</option>
<option value="Finland">Finland</option>
<option value="Germany">Germany</option>
<option value="Guatemala">Guatemala</option>
<option value="Honduras">Honduras</option>
<option value="HongKong">Hong Kong</option>
<option value="Japan">Japan</option>
<option value="Korea">Korea</option>
<option value="NZealand">N. Zealand</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Poland">Poland</option>
<option value="Russia">Russia</option>
<option value="Singapore">Singapore</option>
<option value="Spain">Spain</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="USA">United States</option>
<option value="Uruguay">Uruguay</option>
<option value="Venezuela">Venezuela</option>
<option value="Yugoslavia">Yugoslavia</option>
</select></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top">
<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td align="right" valign="top"><font face="arial,
helvetica, sans-serif" size="2">Click here if you would
like to be on our e-mail list to receive <b>ALL</b> notices
with regard to this site<br></font></td>
<td valign="bottom">
<input type="checkbox" name="email_ok"
value="1"><br></td>
</tr>
<tr>
<td align="right" valign="top"><font face="arial,
helvetica, sans-serif" size="2">Or, if you have a specific
area of interest, check whichever box you would like to
receive information about.</font></td>
<td valign="top"><font face="arial, helvetica,
sans-serif" size="2">
<input type="checkbox" name="feature_stories"
value="1">Feature Stories<br>
<input type="checkbox" name="how_to_light"
value="1">How To Light<br>
<input type="checkbox" name="site_news"
value="1">Site News<br></font>
</td>
</tr>
<tr>
<td align="right"><font face="arial, helvetica, sans-serif" size="2">Occupation/Area of
Interests</font></td>
<td><font face="arial, helvetica, sans-serif"
size="2">
<select name="occupation" size="1">
<option value>Please select... </option>
<option value="engineer">Engineer </option>
<option value="specifier">Specifier </option>
<option value="lighting_designer">Lighting
Designer</option>
<option value="architect">Architect </option>
<option value="hobbyist">Lighting Hobbyist
</option>
<option value="end_user">End User </option>
<option value="other">Other </option>
</select></font>
</td>
</tr>
<tr>
<td align="right" colspan="2">
<input type="submit" value="Submit Form">
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
</td>
</tr>
</table>
<?
}
function enter_info() {
global $fname, $lname, $email, $country, $occupation;
if (empty($fname)) error_message("Please enter a first
name."
;
if (empty($lname)) error_message("Please enter a last
name."
;
if (empty($email)) error_message("Pleae enter an email
address."
;
if (empty($country)) error_message("Please select your
country."
;
if (empty($occupation)) error_message("Please choose an
area of interest."
;
$query = "insert into user values
(NULL, '$fname', '$lname', '$email', '$country', '$email_ok'
, '$feature_stories', '$how_to_light', '$site_news', '$occup
ation', curdate())";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
}
switch($action) {
case "register":
enter_info();
break;
default:
register_email();
break;
}
?>
//<?include "headfoot/global_footer_1.htm"?>
</body>
</html>
any help will be greatly appreciated...
if i'm missing something or if i need something else, please do let me know...i've filled out the form countless number of times but nothing gets entered into the database...
thanks
arif X-) s-)