Cant finde the insert error!!

[Chrysanthus]

Hi i have a problem with inserting a post i make .. the problem with this is that i dont know why it dosent work whenne i try to insert some thing into the db

Please help i don not know what or where i have mist some thing!

there are two file add-maintopic.php and function.php

here is function.php

<?
function addmaintopic () {
global $password,$email,$username,$maintopicname,$maintopicdescription;
	$dst = 0; 
	$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $dst * 3600); 
	$new_post = htmlspecialchars($maintopicdescription);
	$maintopic_insert = mysql_query("INSERT INTO maintopics VALUES ('NULL','$maintopicname','NULL',$username','$email','$password','$new_post','$timestamp')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}

}

and here is the add-maintopic.php

<?php

require( './functions.php');

$action=$_POST["action"]; 
$username=$_POST["username"]; 
$email=$_POST["email"]; 
$password=$_POST["password"];
$maintopicname=$_POST["maintopicname"];
$maintopicdescription=$_POST["maintopicdescription"]; 


if ($action=="add_two") {
	if ($username=="" or $email=="" or $password=="" or $maintopicname=="" or $maintopicdescription=="") {
	echo "You Must Fill in all fields before proceeding";
	exit;
	}
	echo "prutt";
	echo $username;
	echo $password;
	echo $email;
	echo $maintopicname;
	echo $maintopicdescription;

addmaintopic();

echo "Your post was added, and your post password is $password.<P>You may go back now and view it";


function redirect($url,$delay='5') { 
print ' 
    <meta http-equiv="refresh" content="'.$delay.';URL='.$url.'"> 
'; 
} 

redirect("main-topicview.php"); 

echo "<b>Your main topic has been added succesfuly!<br>
	 Now You Will Be Redirect back to nain topic viewbord in 5 Secounds!</B>";


}
else {
?>
<style type="text/css">  

table { width: 100%; border: 0px solid #000000; border-collapse: collapse; }  

td, th { border-top: 0px solid #000000; border-collapse: collapse; padding: 2px; }  

th { text-align: left; font-size: 80%; }  

</style>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100%>
	<TR VALIGN=TOP ALIGN=LEFT>
		<TD WIDTH=100%>
			<TABLE BORDER=0 BGCOLOR="#000000" CELLSPACING=1 CELLPADDING=1 WIDTH=100%>
				<TR>
					<TD COLSPAN=3 BGCOLOR="#C0C0C0" WIDTH=100%>
						<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=5 WIDTH=100%>
							<TR>
								<TD>

							<B><FONT SIZE="-1" COLOR="#000000">
							<TH style="width: 100%;"><b>Flameline Forum Bord</b>
							<br>
							<br>
							<br>
							<a href="main-topicview.php"><FONT COLOR="#000000">Go back to main topic</a>
							</TH>
							</FONT>
							</B>

					</TABLE></TABLE>
				</TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100%>
	<TR VALIGN=TOP ALIGN=LEFT>
		<TD WIDTH=100%>
			<TABLE BORDER=0 BGCOLOR="#000000" CELLSPACING=1 CELLPADDING=1 WIDTH=100%>
				<TR>
					<TD COLSPAN=3 BGCOLOR="#C0C0C0" WIDTH=100%>
						<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=5 WIDTH=100%>
							<TR>
<TD>
<FORM METHOD=POST ACTION="<?php echo $PHP_SELF ?>">
<INPUT TYPE="hidden" name="action" value="add_two">

<tr bgcolor="#C0C0C0">
<td >
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Main Topic Name:</B>
<BR><FONT SIZE="-2">The main topic name can only contane 50 letters.</FONT>
</td><td>
<INPUT TYPE="TEXT" NAME="maintopicname" SIZE=50>
</td></tr>
<tr bgcolor="#C0C0C0">
<td >
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Main Topic Creator:</B></FONT></td><td>
<INPUT TYPE="TEXT" NAME="username" SIZE=25>
</td></tr>
<tr bgcolor="#C0C0C0">
<td>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Creators email:</B></FONT></td>
<td><INPUT TYPE="text" NAME="email" SIZE=25 VALUE="">
</font></td></tr>
<tr bgcolor="#C0C0C0">
<td>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Creators password:</B>
<BR><FONT SIZE="-2">This is used when you would like to edit or delete your maintopic.
</FONT></td><td>
<INPUT TYPE="password" NAME="password" SIZE=25 VALUE="">
</font></td></tr>

<tr bgcolor="#C0C0C0">
<td valign=top>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Main Topic Description:</B></FONT>
<br>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">
<br>
The Description appear exactly as you have submitted them an can only contane 20 Letters. HTML will not be allowed, as the tags are instantly converted into harmless text. Therefore, you cannot have HTML formatting.
</font>
<br><bR>
<input class="button" type="SUBMIT" name="Submit" value="Submit" style="width: 88px; height: 20px;">
<input class="button" type="RESET" name="Reset" value="Clear Fields" style="width: 88px; height: 20px;">
</td>
<td>
<br><br>
<TEXTAREA NAME="maintopicdescription" ROWS=3 COLS=50 WRAP="VIRTUAL"></TEXTAREA></td></tr>
</table>
</td></tr></table> 
<P>
</FORM>
<?php
}
?>

[flatpooks]

ur insert statement is a complete dogs dinner 🙂

insert into table (fieldname1,fieldname2,fieldnamex...) values (value1,value2,valuex)

🙂

[Chrysanthus]

can you specifie your statment ,.. you mean massy?? in works for the other function i made .... or there is some error in the function file...

see here i mabee made some stupid miss that i always do 😃

here is the hole function file

<?php

include ("../Management/mysqlcondbfm.php");

/* add main post */

function addmainpost () {
global $password,$email,$username,$post,$childetopicID,$maintopicID;
	$dst = 0; 
	$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $dst * 3600); 
	$new_post = htmlspecialchars($post);
	$mainpost_insert = mysql_query("INSERT INTO mainposts VALUES ('NULL','$maintopicID','$childetopicID','NULL','$username','$email','$password','$new_post','$timestamp')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}

}

/* delete main posts */

function deletemainpost () {
global $mainpostID;
$mainpost_deletequery = mysql_query("DELETE FROM mainposts WHERE (ID='$mainpostID')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}
}

/* Edite main posts */

function editmainpost () {
global $mainpostID,$post;
	$new_post = htmlspecialchars($post);
	$mainpost_editeinsert = mysql_query("UPDATE mainposts SET post='$new_post' WHERE (ID='$mainpostID')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}
}

/* Add childe topic */

function addchildetopic () {
global $password,$email,$username,$maintopicID,$childetopicname;
	$dst = 0; 
	$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $dst * 3600); 
	$new_post = htmlspecialchars($childetopicname);
	$childetopic_insert = mysql_query("INSERT INTO childetopics VALUES ('NULL','$maintopicID','$new_post','NULL','$username','$email','$password','$timestamp')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}

}

/* Delete childe topic and posted thred in this childe topics */

function deletechildetopic () {
global $childetopicID, $maintopicID;
$childetopic_deletequery = mysql_query("DELETE FROM childetopics WHERE (ID='$childetopicID' AND maintopicID='$maintopicID')");  

$mainpost_deletequery = mysql_query("DELETE FROM mainposts WHERE (maintopicID='$maintopicID' AND childetopicID='$childetopicID')");
if (mysql_error() != "") {
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		exit;
	}
}

function editchildetopic () {
global $maintopicID,$childetopicID,$childetopic_description;
   $new_post = htmlspecialchars($childetopic_description);
   $childetopic_editeinsert = mysql_query("UPDATE childetopics SET childetopicname='$new_post' WHERE (ID='$childetopicID' AND maintopicID='$maintopicID')");
   if (mysql_error() != "") {
      showheader("MySQL Error ".mysql_error());
      ?>
      <br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
      <?php
      exit;
   }
}

function addmaintopic () {
global $password,$email,$username,$maintopicname,$maintopicdescription;
echo $username;

$dst = 0; 
$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $dst * 3600); 
$new_post = htmlspecialchars($maintopicdescription);
$maintopic_insert = mysql_query("INSERT INTO maintopics VALUES ('NULL','$maintopicname','NULL','$username','$email','$password','$new_post','$timestamp')");
if (mysql_error() != "") {
	showheader("MySQL Error ".mysql_error());
	?>
	<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
	<?php
	exit;
}

}


?>
tanks for the help budd

[Chrysanthus]

I have located the problem i forgott a singel qute ' arg stupid me!! now it works!