trying to show results and update a mysql database

[horstuff]

Okay, heres what I have now but it shows nothing. Maybe it would help for you to know that this is all I want this script to do: user sees the page, it says if office is open or closed (by pulling data from field 'hours' in db), dropdown allows them to change status from open to closed or vice versa. So, if thats all this script does, and the code before where I paste it here is just connection stuff, then do I even need thw if's at the beginning? I think I have made this way too complicated. Thanks.

if ( isset( $_POST['action'] ) ) {
   if ( ( $_POST['action'] == "edit" ) && ( empty( $_POST['change'] ) ) ) {      // edit action
       $query = "SELECT * FROM officehours WHERE id=" . $_POST['id'];
       $result = mysql_query($query) or die("Query failed1");
       $row = mysql_fetch_array($result);

   print "<br><br><p align='center'><font face='Verdana' size='2'>The main office is now <b>" . $row[1] . "</b></font></p>";
   print "<form name='change' method='post' action='admin.php'>";
   print "<table width='250' border='0' cellpadding='3' cellspacing='0' align='center'>\n";

   print "<tr bgcolor='#ffffff'><td width='250'><font face='Verdana' size='1' color='#FFFFFF'>ID</font><input type=hidden name=" . $id . " value='0' size='20'></td></tr>";
   print "<tr bgcolor='#000066'><td width='250'><font face='Verdana' size='2' color='#FFFFFF'><b>Change office status:</b>&nbsp;&nbsp;</font><SELECT NAME='poffice'>
<OPTION>Open</option>
<OPTION>Closed</option>
</SELECT></td></tr><tr><td width='250'><br><p align='center'>";
       print "<input type='hidden' name='pid' value=" . $pid . ">";
       print "<input type='hidden' name='action' value='edit'>";
       print "<input type='hidden' name='change' value=1>";
       print "<input type='submit' name='sub' value='Submit'></p></form>";
       print "</td></tr>";

   }


elseif (isset( $_POST['change'])) {    //change action .. goes after edit
       $query = "UPDATE officehours SET id=0,hours='" . $_POST['poffice'] . "' WHERE id=0";
       $result = mysql_query($query) or die("Query failed2");
       echo "Executing elseif statement";

  }
    print "</table>\n";
    }

mysql_close($dbconn);                  //closing connection to database

}
?>

[barand]

I'm assuming hat this script is 'admin.php' as mentioned in the form action (ie the script calls itself, am I right?)

If this is the case, $_POST['id'] will always be blank, unless you happen to to have an office whose id = 'id', as your hidden field is called $id, not "id".

try some simple debugging and add

echo "Query = $query<br>";

before your print statements to see exactly what your query is.

You could also try

foreach($_POST as $k=>$v) {echo "$k = $v<br>";}

to see what was posted

hth