StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Edit - I just realized that your while loop is going to generate something that looks like:</p> <pre><code><input type="text" name="c_name" size="50" value="A1" /><br> <input type="text" name="c_name2" size="50" value="B1" /><br> <input type=button value=\'Submit\' onclick=\'post_value();\'><br><br> <input type="text" name="c_name" size="50" value="A2" /><br> <input type="text" name="c_name2" size="50" value="B2" /><br> <input type=button value=\'Submit\' onclick=\'post_value();\'><br><br> <input type="text" name="c_name" size="50" value="A3" /><br> <input type="text" name="c_name2" size="50" value="B3" /><br> <input type=button value=\'Submit\' onclick=\'post_value();\'><br><br> </code></pre> <p>This isn't going to work because you have multiple elements named "c_name" and "c_name2" within the same form. I think what you want to do is put your form element inside the while loop like this:</p> <pre><code><?php $sql="SELECT * from customer"; $rs=mysql_query($sql,$conn) or die(mysql_error()); $ctr = 0; while($result=mysql_fetch_array($rs)) { echo '<form name="frm' . $ctr . '" method="post" action=""> <input type="text" name="c_name" size="50" value="'.$result["sequence"].'" /><br> <input type="text" name="c_name2" size="50" value="'.$result["company"].'" /><br> <input type=button value=\'Submit\' onclick=\'post_value(' . $ctr . ');\'><br><br>' </form>'; $ctr++; } ?> </code></pre> <p>Notice how I created a $ctr variable so you can identify each form and how it is passed into post_value. You'll need to use that to grab the correct form like this:</p> <pre><code><script langauge="javascript"> function post_value(ctr) { opener.document.f1.p_name.value = document.forms["frm" + ctr].c_name.value; opener.document.f1.p_name2.value = document.forms["frm" + ctr].c_name2.value; self.close(); } </script> </code></pre> <p>By default, mysql_fetch_array returns an array with numeric keys (i.e. 0, 1, 2, etc). If you want to retrieve records by their column name, you need to use:</p> <pre><code>while ($result = mysql_fetch_array($rs, MYSQL_ASSOC)) </code></pre> <p>Look at example 3 here:</p> <p><a href="http://php.net/manual/en/function.mysql-fetch-array.php" rel="nofollow">http://php.net/manual/en/function.mysql-fetch-array.php</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload