chrisboydell71 Posted October 20, 2012 Share Posted October 20, 2012 Hello everyone. I've got a problem with a webform that uses PHP. I'm sure it's very obvious but can't find the problem. What I want to do is basically enter a numerical value into a field on a form, which then sends the value to a mysql database, requesting a record linked to that value. A window opens with the record requested. The problem I am getting is that the value is not being taken properly when I hit the 'submit' button, but will take the previous value that was submitted a previous query. For example, I want to retrieve a record that has an 'id' of 1. I enter '1' into the field (the id of the field is 'identry'), I get an error. The error basically signifies staes that I have not entered a value into the 'id' field, for some reason. Then I access the search field again, enter a value of '2', and hit the 'submit'. I then get a result that it has just accessed record with 'id' of '1' (the previous query!!!!) Any ideas?? This is my code for the form..... <form id="form1" name="form1" method="post" > <table width="400" border="0"> <tr> <td width = "150" ><div align="right">HPOV reference </div></td> <td width = "150"><label> <input name= "identry" type="text" id="identry" /> </label></td> <td width = "100"><label> <div align="left"> <input name="Submit" type="submit" onclick="MM_openBrWindow('HPOVwindow.php?id=<?php echo $_POST['identry']; ?>','','toolbar=yes,location=yes,status=yes,menubar=yes,scrollbars=yes,resizable=yes,width=1000,height=1000')" /> </div> </label></td> </tr> </table> </div> </form> Apologies if this is in the wrong place. Thank you for reading. Chris Quote Link to comment Share on other sites More sharing options...
Christian F. Posted October 20, 2012 Share Posted October 20, 2012 How does your PHP code look like? Quote Link to comment Share on other sites More sharing options...
chrisboydell71 Posted October 20, 2012 Author Share Posted October 20, 2012 (edited) Here is the full code for the page <?php require_once('../Connections/HPOV.php'); ?> <?php mysql_select_db($database_HPOV, $HPOV); $query_rsjob_id = "SELECT distinct id FROM jobs"; $rsjob_id = mysql_query($query_rsjob_id, $HPOV) or die(mysql_error()); $row_rsjob_id = mysql_fetch_assoc($rsjob_id); $totalRows_rsjob_id = mysql_num_rows($rsjob_id); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[url="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd%22>"]http://www.w3.org/TR...nsitional.dtd">[/url] <html xmlns="[url="http://www.w3.org/1999/xhtml%22>"]http://www.w3.org/1999/xhtml">[/url] <head> <title>Outer Space - Free Web Template by WebTemplateOcean.com</title> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="content-language" content="" /> <link href="style.css" rel="stylesheet" type="text/css" /> <script type="text/Javascript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <div id="page"> <div id="header"> <a href="#"><img id="logo" src="images/logo.jpg" alt="" /></a> <h1><a href="#">HP Openview Listings</a></h1> </div> <div id="menu"> <ul> <li><a href="#">Search</a></li> <li><a href="fulllist.php">Full List</a></li> <li><a href="#">Help</a></li> <li><a href="#">Contact</a></li> </ul> </div> <div id="main"><div id="main2"> <p> <!-- content --></p> <form id="form1" name="form1" method="post" > <div align="center"> <table width="397" border="0"> <tr> <td width = "150" height="24" ><div align="right">HPOV reference </div></td> <td width = "150"><label> <input name= "identry" type="text" id="identry" /> </label></td> <td width = "100"><label> <input name="Submit" type="submit" onclick="MM_openBrWindow('HPOVwindow.php?id=<?php echo $_POST['identry']; ?>','','toolbar=yes,location=yes,status=yes,menubar=yes,scrollbars=yes,resizable=yes,width=1000,height=1000')" /> </label></td> </tr> </table> </div> </form> <p> </p> <p> </p> <p> </p> <p> </p> <div class="clearing"> </div> </div> </div><!-- main --><!-- main2 --> <div id="footer"> </div> Hope this helps. Edited October 20, 2012 by chrisboydell71 Quote Link to comment Share on other sites More sharing options...
rmember Posted October 22, 2012 Share Posted October 22, 2012 you forgot the action="mypage.php" lol thats all Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted October 22, 2012 Share Posted October 22, 2012 (edited) It submits to itself, so the action attribute shouldn't be necessary (with most browsers), although it doesn't comply with the specs. The best way to handle it would be to use an empty action attribute, e.g., action="" Edited October 22, 2012 by Pikachu2000 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.