Blank page after data submision

[trh5001]

Alright my problem is I after submiting a form my page goes blank and the data isnt saved to the mysql database here is my code.

Code: [Select]

<?php
if(isset($_POST['Submit'&#93;))
{
$db_host='localhost';
$db_user='******_frazier';
$db_pass='******';
$db_name=******_fraziercompanies;
$db = mysql_connect($db_host, $db_user, $db_pass); 
mysql_select_db($db_name,$db);

$sql = "INSERT INTO $db_table(CompanyID,CompanyName,CompanyContact,CompanyPhone,CompanyDinner,CompanyAddress,CompanyCity,CompanyState,CompanyZIP,CompanyEmail,CompanyPlayers,CompanyPlayer1,CompanyPlayer1HC,CompanyPlayer2,CompanyPlayer2HC,CompanyPlayer3,CompanyPlayer3HC,CompanyPlayer4,CompanyPlayer4HC)
VALUES
('$_POST[Company_Name&#93;','$_POST[Company_Contact&#93;','$_POST[Company_Address&#93;','$_POST[Company_City&#93;','$_POST[Company_State&#93;','$_POST[Company_ZIP&#93;','$_POST[Company_BusPhone&#93;','$_POST[Company_AltPhone&#93;','$_POST[Company_MobPhone&#93;','$_POST[Company_NumPlayers&#93;','$_POST[Player_Name1&#93;','$_POST[Player_Handicap1&#93;','$_POST[Player_Name2&#93;','$_POST[Player_Handicap2&#93;','$_POST[Player_Name3&#93;','$_POST[Player_Handicap3&#93;','$_POST[Player_Name4&#93;','$_POST[Player_Handicap4&#93;')";
mysql_query($sql);
}
else
{
?>

<form name="form1" id="form1" method="post">
<span class="left">
        <label style="vertical-align: middle">Company Name:        
        <input name="Company_Name" type="text" style="vertical-align: middle" value="" size="20" />
        <br />
      </label>
        <label> Company Contact:
        <input name="Company_Contact" type="text"style="vertical-align: middle" size="20"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company Address:
        <input type="text" name="Company_Address" style="vertical-align: middle"/>
</label>
        <br />
        <label style="vertical-align: middle">Company City:
        <input type="text" name="Company_City" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company State:
        <input type="text" name="Company_State" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company ZIP:
        <input type="text" name="Company_ZIP" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company Business Phone:
        <input type="text" name="Company_BusPhone" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company Alternate Phone:
        <input type="text" name="Company_AltPhone" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Company Mobile Phone:
        <input type="text" name="Company_MobPhone" ="" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Number of Players:
        <input type="text" name="Company_NumPlayers" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle">Dinner:
        <input type="text" name="Company_Dinner" style="vertical-align: middle"/>
        </label>
        <br />
        <label style="vertical-align: middle"></label>
        <br />
        <label style="vertical-align: middle"></label>
        <br />
       
        <label style="vertical-align: middle"></label>
      </span>
            <span class="center">
            <label style="vertical-align: middle">Payment Method:
            <input type="text" name="Company_Payment" style="vertical-align: middle"/>
            <br />
            Credit Card Type:
            <input type="text" name="Company_CardType" style="vertical-align: middle"/>
            <br />
Credit Card Number:
<input type="text" name="Company_CardNumber" style="vertical-align: middle"/>
<br />
Player Name:
            <input type="text" name="Player_Name1" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Handicap:
            <input type="text" name="Player_Handicap1" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Name:
            <input type="text" name="Player_Name2" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Handicap:
            <input type="text" name="Player_Handicap2" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Name:
            <input type="text" name="Player_Name3" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Handicap:
            <input type="text" name="Player_Handicap3" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Name:
            <input type="text" name="Player_Name4" style="vertical-align: middle"/>
            </label>
            <br />
            <label style="vertical-align: middle">Player Handicap:
            <input type="text" name="Player_Handicap4" style="vertical-align: middle"/>
            </label>
            <br />
            <input name="Submit" type="submit" id="Submit" />
            </span>          
      </form>
          <span class="left">        </span>        <br />
      </span>
 <?php
  }
  ?>
        </form>
MOD EDIT: Added code tags

[Zyppora]

Are you getting any errors? If so, post them here. What have you tried to solve the issue? What exactly is it doing that it shouldn't, and what does it not do that it should? Have you tried debugging, see my signature? Have you tried googling?

I'm very tempted to just close this thread. You don't provide -any- information whatsoever, you just paste a huge chunk of code here and expect us to find and solve your problem.

Alright my problem is ...

That's right, it's YOUR problem. And we can only point you in the right direction towards solving it. We're not a script fixing service.