scarface83 Posted October 11, 2007 Share Posted October 11, 2007 Hi i was wondering if anyone could help me with the below code its a form which posts back into itself so i can move on the the next drop down but it doesnt seem to be working and i have been starring at it for ages it used to work and nothing has changed ? thanks <? //echo "Site Down while making improvements -" ,$days; //exit(); session_start(); print_r ($_SESSION); include('sess_vars.php'); if($level >=1){echo "If you are seeing this you dont have sufficent rights to access this program? if not email rob please !!!!";} else { if (isset($none_sel)) // if the loginerror variable is set then continue echo $none_sel; // unset($_SESSION['none_sel']); // unregisters the session for none_sel so it can be reset later in the script @$error = $_GET['error']; if($error=="1") { echo ("Select an option below before submitting."); unset($error); } require ('db_connect.inc'); // includes db connection details if(isset($teams)) { $set_teams = $_POST['teams']; } else { $set_teams="Please_Select";} $team_names = mysql_query("SELECT TeamRef,Teamname FROM a_team WHERE In_use='Y' AND Area='1' ORDER BY Teamname ") or die(mysql_error); if(isset($advisors)) { $set_advisors = $_POST['advisors']; } else { $set_advisors="Please_Select";} $advisor_names = mysql_query("SELECT nick FROM a_users WHERE In_use='Y' AND Level='0' AND TeamRef='$set_teams' ORDER BY nick"); mysql_close(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Absence Managment</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <div class="title"> <u>Absence Management</u></div> <div class="back"><a href="../main.php">Back</a></div> <form name="select_advisor" method="post" action="report_absence.php"> <br /> <table width="1395" border="0"> <tr> <td width="865"><b><u>Please Select the team, then the advisor you are reporting the absence for </u></b></td> </tr> </table> </div> </p> <table width="14%" border="1"> <tr> <td width="78%"><div align="left"> <select name="teams" onChange="this.form.submit();"> <option value="Please_Select">Please Select</option> <? while($team_names_row = mysql_fetch_array($team_names)) { extract($team_names_row) ?> <? if($set_teams==$TeamRef) { ?> <option style="color:#FF0000" value="<? echo $TeamRef ?>" selected><? echo $Teamname; ?></option> <? } else { ?> <option value="<? echo $TeamRef ?>"><? echo $Teamname; ?></option> <? } ?> <? } ?> </select> </div> </td> <!-- <td width="22%"><input type="submit" name="Submit" value="Select"></td> --> </tr> <tr> <td><div align="left"> <select name="advisors" onChange="this.form.submit();"> <option value="Please_Select">Please Select</option> <? while($advisor_names_row = mysql_fetch_array($advisor_names)) { extract($advisor_names_row) ?> <? if($set_advisors==$nick) { ?> <option style="color:#FF0000" value="<? echo $nick ?>" selected><? echo $nick; ?></option> <? } else { ?> <option value="<? echo $nick ?>"><? echo $nick; ?></option> <? } ?> <? } ?> </select> <label></label> </div></td> <!-- <td><input type="submit" name="Submit2" value="Select"></td> --> </tr></table> </form> <form name="form2" method="post" action="report_absence2.php"> <br /> <table border="1"> <td width="56"><input type="submit" name="Submit3" value="Submit" /> </table> <input type="hidden" name="whats_sel" value="4" /> <input type="hidden" value="<? echo $set_teams ?>" name="teams" /> <input type="hidden" value="<? echo $set_advisors ?>" name="advisors" /> </form> <p> <div class="footer"> </p> <p> </p> </body> Link to comment https://forums.phpfreaks.com/topic/72843-old-code-new-problems/ Share on other sites More sharing options...
scarface83 Posted October 12, 2007 Author Share Posted October 12, 2007 anyone ? Link to comment https://forums.phpfreaks.com/topic/72843-old-code-new-problems/#findComment-367675 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.