[Resolved] Problem with making a new variable from two other variables

[badgoat]

Hi!

I heard this can be done, so I made a little test to see if I could do it. The variables firstname and lastname do get into the db, but wholename does not. What am I doing wrong?

name.php:

$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$wholename=firstname.lastname;  

?>
<form action="name1.php" method="post">
<input type=text name="firstname" size=32>
<input type=text name="lastname" size=32>
<input type="submit" name="Submit" value="Submit" action="required"></FORM>

name1.php:

$sqlquery = "INSERT INTO name VALUES('". $_POST['firstname'] ."','". $_POST['lastname'] ."','".$wholename."')";
$queryresult = mysql_query($sqlquery) or die(" Could not execute mysql query !");
$sqlquery = "SELECT * from name  ";



echo '<table>
<tr>
<td>Full Name is:</td>
<td>'.$_POST['wholename'].'</td>
</tr>		 
<Table>	';


?>		

[kkobashi]

In your form's action statement, it calls up name1.php. You should check for the firstname, and lastname variables there, instead of in name.php. Name.php knows nothing about the post variables since they are not set.

Do this:

name.php

<Leave your html form stuff in this file>

name1.php

Move the three variables in this file, then do your database stuff.

$firstname=$POST['firstname'];
$lastname=$POST['lastname'];
$wholename=firstname.lastname;

<Database stuff>

[badgoat]

Thank you kindly! That worked!

[travelbuff]

$wholename=$firstname.$lastname;  

You forgot the $ signs on the vars.

[badgoat]

Yea, I had to tweak my script as there were a couple little noob errors I made, that being one of them. I changed that whole row to be

$wholename=$firstname." ".$lastname;