what happens is that when i fill in the form and press submit i get the thanx word but the data doesnt end up in my mysql database
these are the pages i used
the form page :
<head>
<title>
Digitaltekno.com
</title>
</head>
<body bgcolor="#bebebe"><?
include("header.html")
?><? include("login.html")?>
<table cellspacing="20" align="left">
<tr>
<td><? include("menu.html")?>
</td></tr>
</table>
<table width="95%" cellspacing="10" align="left"></table>
<table cellspacing="10" cellpadding="0" border="0">
<tr> Dj submission Form<br>please
first make the style, history, experience and booking info in an html editot and<br>then copy/paste the html code between the <body></body> tags
</tr> <form action=subdj.php method=post>
<tr>
<td> Dj Name:
</td>
<td>
<input name="djName" size="25" maxlength="50">
</td>
</tr>
<tr>
<td> Starting year?:
</td>
<td>
<input name="djStart" size="4" maxlength="4">
</td>
</tr>
<tr>
<td> With what do you play:
</td>
<td>
<select name="djType">
<option selected>LP</option>
<option>CD</option>
<option>LP/CD</option>
<option>Other</option>
</select>
</td>
</tr>
<tr>
<td> Iff you selected other fill here in what:
</td>
<td>
<input name="djTypee" size="25" maxlength="50">
</td>
</tr>
<tr>
<td> What styles do you play:
</td>
<td><TEXTAREA cols=40 name=djStyle rows=3></TEXTAREA>
</td>
</tr>
<tr>
<td> The History of you as a dj please be complete
(like a short story something like this happend and then i just wanted to
play some tracks, then i bought my first turntable, i hope you get the picture):
</td>
<td><TEXTAREA cols=40 name=djHist rows=5></TEXTAREA>
</td>
</tr>
<tr>
<td> Your experience on parties/dancings/...:
</td>
<td><TEXTAREA cols=40 name=djExp rows=5></TEXTAREA>
</td>
</tr>
<tr>
<td> Your Favorite Track:
</td>
<td>
<input name="djTrack" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Your Favorite Dj:
</td>
<td>
<input name="djDj" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Your Favorite Live act:
</td>
<td>
<input name="djLive" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Some picture of you (url starting including <!-- m --><a class="postlink" href="http://">http://</a><!-- m -->, only 1 url per box):
</td>
<td>
Picture 1:
<input name="djPic1" size="25" maxlength="254"><br>
Picture 2:
<input name="djPic2" size="25" maxlength="254"><br>
Picture 3:
<input name="djPic3" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Where do you live:
</td>
<td>
<input name="djHome" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> What should poeple do when they want to book you for a night:
</td>
<td><TEXTAREA cols=40 name=djBook rows=4></TEXTAREA>
</td>
</tr>
<tr>
<td> The best Club:
</td>
<td>
<input name="djClub" size="25" maxlength="254">
</td>
</tr>
tr>
<td> The best event:
</td>
<td>
<input name="djEvent" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Anny Final words?
</td>
<td><TEXTAREA cols=40 name=djQuote rows=4></TEXTAREA>
</td>
</tr>
<tr>
<td>
<input type="submit" value=http://www.phpbuilder.com/board/archive/index.php/"Submit">
</td>
</tr>
</table><br><br><br><br></FORM>
<P></P>
</body>
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
the submission page subdj.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<head>
<title>DigitalTekno.com</title>
</head><body bgcolor="bebebe">
<?
include("header.html");
include("login.html")?><table width="95%" cellspacing="20" align="left"><tr><td>
<?include("menu.html")?></td><td>
<?$openDB = mysql_connect("db.geel.f2s.com:3306","gellow","mrgeel");
mysql_select_db("gellow");
mysql_query ("INSERT INTO dj (djName, djStart, djStyle, djHist, djExp, djType, djTypee, djTrack, djDj, djLive, djQuote, djPic1, djPic2, djPic3, djHome, djBook, djClub, djEvent)
VALUES ('$djName', '$djStart', '$djStyle', '$djHist', '$djExp', '$djType', '$djTypee', '$djTrack', '$djDj', '$djLive', '$djQuote', '$djPic1', '$djPic2', '$djPic3', '$djHome', '$djBook', '$djClub', '$djEvent')");
print ($djName);
print ("Thanks for submitting yourself.");
?>
</td></tr>
</table>
</body>
these are the pages i used
the form page :
<head>
<title>
Digitaltekno.com
</title>
</head>
<body bgcolor="#bebebe"><?
include("header.html")
?><? include("login.html")?>
<table cellspacing="20" align="left">
<tr>
<td><? include("menu.html")?>
</td></tr>
</table>
<table width="95%" cellspacing="10" align="left"></table>
<table cellspacing="10" cellpadding="0" border="0">
<tr> Dj submission Form<br>please
first make the style, history, experience and booking info in an html editot and<br>then copy/paste the html code between the <body></body> tags
</tr> <form action=subdj.php method=post>
<tr>
<td> Dj Name:
</td>
<td>
<input name="djName" size="25" maxlength="50">
</td>
</tr>
<tr>
<td> Starting year?:
</td>
<td>
<input name="djStart" size="4" maxlength="4">
</td>
</tr>
<tr>
<td> With what do you play:
</td>
<td>
<select name="djType">
<option selected>LP</option>
<option>CD</option>
<option>LP/CD</option>
<option>Other</option>
</select>
</td>
</tr>
<tr>
<td> Iff you selected other fill here in what:
</td>
<td>
<input name="djTypee" size="25" maxlength="50">
</td>
</tr>
<tr>
<td> What styles do you play:
</td>
<td><TEXTAREA cols=40 name=djStyle rows=3></TEXTAREA>
</td>
</tr>
<tr>
<td> The History of you as a dj please be complete
(like a short story something like this happend and then i just wanted to
play some tracks, then i bought my first turntable, i hope you get the picture):
</td>
<td><TEXTAREA cols=40 name=djHist rows=5></TEXTAREA>
</td>
</tr>
<tr>
<td> Your experience on parties/dancings/...:
</td>
<td><TEXTAREA cols=40 name=djExp rows=5></TEXTAREA>
</td>
</tr>
<tr>
<td> Your Favorite Track:
</td>
<td>
<input name="djTrack" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Your Favorite Dj:
</td>
<td>
<input name="djDj" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Your Favorite Live act:
</td>
<td>
<input name="djLive" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Some picture of you (url starting including <!-- m --><a class="postlink" href="http://">http://</a><!-- m -->, only 1 url per box):
</td>
<td>
Picture 1:
<input name="djPic1" size="25" maxlength="254"><br>
Picture 2:
<input name="djPic2" size="25" maxlength="254"><br>
Picture 3:
<input name="djPic3" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Where do you live:
</td>
<td>
<input name="djHome" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> What should poeple do when they want to book you for a night:
</td>
<td><TEXTAREA cols=40 name=djBook rows=4></TEXTAREA>
</td>
</tr>
<tr>
<td> The best Club:
</td>
<td>
<input name="djClub" size="25" maxlength="254">
</td>
</tr>
tr>
<td> The best event:
</td>
<td>
<input name="djEvent" size="25" maxlength="254">
</td>
</tr>
<tr>
<td> Anny Final words?
</td>
<td><TEXTAREA cols=40 name=djQuote rows=4></TEXTAREA>
</td>
</tr>
<tr>
<td>
<input type="submit" value=http://www.phpbuilder.com/board/archive/index.php/"Submit">
</td>
</tr>
</table><br><br><br><br></FORM>
<P></P>
</body>
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
the submission page subdj.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<head>
<title>DigitalTekno.com</title>
</head><body bgcolor="bebebe">
<?
include("header.html");
include("login.html")?><table width="95%" cellspacing="20" align="left"><tr><td>
<?include("menu.html")?></td><td>
<?$openDB = mysql_connect("db.geel.f2s.com:3306","gellow","mrgeel");
mysql_select_db("gellow");
mysql_query ("INSERT INTO dj (djName, djStart, djStyle, djHist, djExp, djType, djTypee, djTrack, djDj, djLive, djQuote, djPic1, djPic2, djPic3, djHome, djBook, djClub, djEvent)
VALUES ('$djName', '$djStart', '$djStyle', '$djHist', '$djExp', '$djType', '$djTypee', '$djTrack', '$djDj', '$djLive', '$djQuote', '$djPic1', '$djPic2', '$djPic3', '$djHome', '$djBook', '$djClub', '$djEvent')");
print ($djName);
print ("Thanks for submitting yourself.");
?>
</td></tr>
</table>
</body>