Parse Error Problem

DRTechie

Hello everyone, I am getting a parse error on a piece of code I wrote and after looking at it for so long I can't figure it out. The error is in line 23 which is the "<INPUT TYPE>" line. As you can see, I am trying to pass the variable $sitename to the page indicated under the redirect...am I doing that right? any help is greatly appreciated.

<?
if ((!$sitename) || (!$address1)) {
header ("Location: addsite.php");
exit;

} else {
//connect to the database and store all the information
$db_name = "system_outage";
$table_name = "site";
$connection = mysql_connect("localhost", "root", "netops") or die ("could not connect do database");
$db = mysql_select_db($db_name, $connection) or die ("cannot select database");

$sql = "INSERT INTO $table_name (sitename,address1,address2, city, state, postal_code, setup, site_status, contacts, description, notes)

VALUES (\"$sitename\",\"$address1\", \"$address2\", \"$city\", \"$state\", \"$postal_code\", \"$setup\", \"$site_status\", \"$contacts\", \"$description\", \"$notes\")";

 $result = mysql_query($sql) or die ("could not execute query");

header ("Location: addcircuit.php");
exit;

whaites

you are not echoing the input tag to the browser

echo "<INPUT TYPE=\"hidden\" name=\"sitename\" value=\"$sitename\">";

DRTechie

cool. That got rid of the parse error but it's still not passing the variable to the next page. any ideas on that?

whaites

What are you trying to do?
The hidden input will not submit the value to the next page for two reasons:
1. There is no submit button.
2. (More importantly) The input button is after your exit command. No code after the exit command is executed.

If you just want the variable passed to the redirect page, try:

header ("Location: addcircuit.php?sitename=$sitename");
exit;

DRTechie

Thanks whaites, it's all working now.