making blank fealds. inserts non values

[Chrysanthus]

Hi

I have a problem and i hop some body can help me with this!
How do i get the function $topicID = addtopic(); to add the topic post value into the functions.php skript and then after insert the value into mysql!
what i see seems everything to look allright but it inserts bank fealds in the mysql and that means that the posts are not beaing inserted into mysql!

Here are a lite clip of add-topic.php
<?php

require('./functions.php');


$action=$POST["action"];
$name=$POST["name"];
$email=$POST["email"];
$password=$POST["password"];
$post=$_POST["post"];


if ($action) {
if ($name=="" or $email=="" or $password=="" or $post=="") {
showheader("All the Fields Have Not Been Filled in");
echo "You Must Fill in all fields before proceeding";
showfooter();
exit;
}
$topicID = addtopic();
addpost();
showheader("Your Post has successfully been added");
echo "Your post was added, and your post password is $password.<P>You may go back now and view it";
showfooter();
}
else {
?>

Here is a clip from the functions.php skript that im trying to get it to work..

<?

function addtopic () {
global $topicname;
$new_topicname = addslashes($topicname);
$topic_query = mysql_query("INSERT INTO topics VALUES ('NULL','$new_topicname')");
if (mysql_error() != "") {
showheader("MySQL Error ".mysql_error());
?>
<br><p><center><b><FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
<?php
showfooter();
exit;
}
return mysql_insert_id();
}


?>

[OhLordy]

You never set $topicname;
in the addtopic() function you have the following lines.

<?
global $topicname;
$new_topicname=addslashes($topicname);
?>

but you have not set $topicname andwhere
HTH
Rob

[Chrysanthus]

thanks just when i got youre e-mail i solved by making this

$topicname=$_POST["topicname"];

was it that you meant? if not?

[Chrysanthus]

Sorry! here is the the rest of the script

<?php

require('./functions.php');


$action=$POST["action"];
$name=$POST["name"];
$email=$POST["email"];
$password=$POST["password"];
$post=$POST["post"];
$topicname=$POST["topicname"];


if ($action) {
if ($name=="" or $email=="" or $password=="" or $post=="") {
showheader("All the Fields Have Not Been Filled in");
echo "You Must Fill in all fields before proceeding";
showfooter();
exit;
}
$topicID = addtopic();
addpost();
showheader("Your Post has successfully been added");
echo "Your post was added, and your post password is $password.<P>You may go back now and view it";
showfooter();
}
else {
?>
<TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5>
<TR>
<TD>
<FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1>
<P>
<a href="index.php"><FONT COLOR="#000000">Return Back to Topics</a>
</TD>
</TR>
</TABLE>
<FORM METHOD=POST ACTION="<?php echo $PHP_SELF?>">
<INPUT TYPE="hidden" name="action" value="add_two">
<table border=0 cellpadding=0 cellspacing=0 width="95%">
<TR><td bgcolor="#000000">
<table border=0 cellpadding=4 cellspacing=1 width=100%>
<tr bgcolor="#C0C0C0">
<td >
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Topic Name:</B></FONT></td><td>
<INPUT TYPE="TEXT" NAME="topicname" SIZE=25>
</td></tr>
<tr bgcolor="#C0C0C0">
<td >
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your UserName:</B></FONT></td><td>
<INPUT TYPE="TEXT" NAME="name" SIZE=25>
</td></tr>
<tr bgcolor="#C0C0C0">
<td>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Your Email Address:</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>Your Password:</B>
<BR><FONT SIZE="-2">This is used when you would like to edit or delete your post.
</FONT></td><td>
<INPUT TYPE="password" NAME="password" SIZE=13 VALUE="">
</font></td></tr>

<tr bgcolor="#C0C0C0">
<td valign=top>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica"><B>Post:</B></FONT>
<p><BR>
<FONT SIZE="-1" FACE="Trebuchet MS,Arial,Helvetica">
Posts appear exactly as you have submitted them. HTML is not allowed, all text instantly converted into harmless text. Therefore, you cannot have HTML formatting in this forum.
</p></font>
</td>
<td>
<TEXTAREA NAME="post" ROWS=10 COLS=45 WRAP="VIRTUAL"></TEXTAREA></td></tr>
</table>
</td></tr></table>
<P>
<CENTER>
<INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Submit Post">
<INPUT TYPE="RESET" NAME="Reset" VALUE="Clear Fields">
<br>
</CENTER>
</FORM>
<?php
}
?>

[OhLordy]

Yea, that's what I meant. Good to hear it's working. You can mark this thread resolved by clicking the link at the bottom of the page
Cheers
Rob