StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18355131
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-08-21T10:34:56.887
FavoriteCount
0
LastActivityDate
2013-08-21T11:25:33.840
LastEditDate
2013-08-21T11:25:33.840
LastEditorUserId
1850534
OwnerUserId
1850534
ParentId
18354226
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You can't do it by the way you tried.There are two better ways to do it <ol> <li>Use <code>Ajax</code>.</li> <li>Use Cookies The best way here is to use Ajax. Here, iam using <code>javascript</code> and <code>ajax</code>.And i am creating a new file to create response(say newfile.php) Try this, <pre><code>function getCode(){ var v =document.forms["form1"]["part_code"].value; var x = document.forms["form1"]["part_code"].value; var y = document.forms["form1"]["location_code"].value; var z = document.forms["form1"]["date"].value; var xmlhttp; if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { var getPartCode=xmlhttp.responseText; //Getting the response from php file var a = (getPartCode + '/'+x +'/'+ y +'/'+ z); document.forms["form1"]["invent_code"].value = a; } } xmlhttp.open("GET","newFile.php?q="+v,true); //Sending request to newfile.php xmlhttp.send(); } </script> </code></pre></li> </ol> newfile.php <pre><code><?php $value = $_GET["q"]; //getting the value sent through tthe ajax request $query = mysql_query("SELECT COUNT(*)+1 as count FROM TB_TRANSACTION where part_code = '$value'"); $i=-1; while ($code_part = mysql_fetch_array($query)) { $i++; echo $code_part['count']; } ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POParsing Javascript Variable into php query
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USraduns
UserOwnerUserId
1. USraduns
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POParsing Javascript Variable into php query
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COcould do indent your code? Even if i know what you are trying to do it's kind of difficult to read it
 singulars
 PostPostId
 PO
 UserUserId
 USfGo
2. COraduns, I use code igniter framework. i dont know how to load view .. in thats script xmlhttp.open("GET","newFile.php?q="+v,true); Thanks for the reply
 singulars
 PostPostId
 PO
 UserUserId
 USokywijaya

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.