and my join file is where do i put it please and thanks for this (half my join.php file)
<?php
// ...
$act=form_get("act");
if($act=='')
{$was=time()-3600*24;
$sql_query="delete from members where verified='n' and joined<$was";
sql_execute($sql_query,'');sign_up_form();}
elseif($act=='reg')
{do_register();}
elseif($act=='val'){validate();} //showing sign-up formfunction sign_up_form(){$inv_id=form_get("inv_id");if($inv_id!=''){ $sql_query="select mem_id from invitations where inv_id='$inv_id'"; $inv=sql_execute($sql_query,'get'); $sql_query="select fname,lname from members where mem_id='$inv->mem_id'"; $mem=sql_execute($sql_query,'get');}$sql_accc="select * from member_package order by package_amt";$res_accc=mysql_query($sql_accc);show_header();echo '<table width="600" align=center>';?><form action="index.php" method=post><input type="hidden" name="mode" value="join"><input type="hidden" name="act" value="reg"><input type="hidden" name="inv_id" value="<? echo $inv_id; ?>"><tr><td> </td><tr><td class="lined bold padded-6">Join our net</td><tr><td height="5"></td><tr><td class="lined"><table class="body" cellspacing=5 cellpadding=2><tr><td colspan=3><p class="bodygray bold">Become a Registered User<? if($inv_id==''){ ?><p>Fill out the form below to become a member.<? } else { ?><p><? echo "$mem->fname $mem->lname "; ?>invited you to become a member.<? } ?><p>We take your <a href="index.php?mode=privacy">privacy</a> very seriously. We will not sell or exchange your e-mail address with anyone.</br></br><p class="orangebody">All fields are required!</br> </td><tr><td>First Name</td><td><input type="text" name="fname"></td><td rowspan=2 class="lined form_tip">Your full name will only be shown to your friends.</td><tr><td>Last Name</td><td><input type="text" name="lname"></td><tr><td>E-mail</td><td><input type="text" name="email"></td><td rowspan=2 class="lined form_tip">This is your login ID; this e-mail address must be verified before you can fully explore our site</td><tr><td>Confirm E-mail</td><td><input type="text" name="email2"></td><tr><td>Password</td><td><input type="password" name="password"></td><td class="lined form_tip">Passwords must be 4-12 characters.</td><tr><td>Confirm Password</td><td><input type="password" name="password2"></td><td></td><tr><td>ZIP/Postal Code</td><td><input type="text" name="zip"></td><td rowspan=2 class="lined form_tip">This information enables you to see local content. You may hide your location from others.</br><input type=checkbox name="showloc" value="0">Don't show my location</td><tr><td>Country</td><td><select name="country"><? country_drop(); ?></select></td><tr><td>Gender</td><td><input type="radio" name="gender" value="m">Male</br><input type="radio" name="gender" value="f">Female</br><input type="radio" name="gender" value="n">I'd prefer not to say</br></td><td rowspan=2 class="lined form_tip">You may hide this information from others.</br><input type=checkbox name="showgender" value="0">Don't show my gender</br><input type=checkbox name="showage" value="0">Don't show my age</td><tr><td>Birthday</td><td><select name=month><option selected value="0">Month<? month_drop(0); ?></select><select name=day><option selected value="0">Day<? day_drop(0); ?></select><select name=year><option selected value="0">Year<? year_drop('0'); ?></select></td><tr><td colspan=3></td></tr><tr><td valign="top">Membership Type</td><td valign="top"> <?php $ssco=1; if(mysql_num_rows($res_accc)) { while($row_accc=mysql_fetch_object($res_accc)) { if($ssco==1) $dis="<input type='radio' name='pack' value='$row_accc->package_id' checked> ".$row_accc->package_nam." "; else $dis="<input type='radio' name='pack' value='$row_accc->package_id'> ".$row_accc->package_nam." "; if($row_accc->package_amt!='0.00') $dis.=" ‹ $".$row_accc->package_amt." ›";?> <?=$dis?> <br><?php $ssco++; $dis=""; }}?></td><td rowspan=2 class="lined form_tip" valign="top"> Select Membership Package</td><tr><td colspan=3> </td><tr><td colspan=3 class="td-lined-top" height=3></td><tr><td colspan=3> </td><tr><td colspan=3 align="center"><input type=checkbox name="terms" value=1>I have read and agree to the<a href='index.php?mode=terms'>Terms of Use</a></td><tr><td colspan=3> </td><tr><td colspan=3 align="right"><input type=submit value="Register"></td><tr><td colspan=3> </td></form></table></td><tr><td><table><tr><td class="lined body padded-6" valign=top><span class="subtitle">This site requires cookies</span></br></br>Our site uses cookies to provide you with a reliable, consistent experience as you browse the site. Please make sure your browser can accept cookies.</td><td class="lined body padded-6" valign=top><span class="subtitle">Using a Spam Filter?</span></br></br>Add our site to your list of approved domains now so you can receive your registration confirmation and messages from other members.</td><td class="lined body padded-6" valign=top><span class="subtitle">What's in a Name
