StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POReorder pages in a menu system
primarykey
Id
9379201
data
AcceptedAnswerId
9379583
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-21T14:24:34.030
FavoriteCount
0
LastActivityDate
2012-02-21T14:50:02.230
LastEditDate
LastEditorUserId
0
OwnerUserId
511886
ParentId
0
PostTypeId
1
Score
0
ViewCount
129
LastEditorDisplayName
text
Body
<p>I have written a chunk of code that is aimed at reordering pages.</p> <pre><code><form action="process.php" method="post" /> <?php $apageid = array(); $apagename = array(); $q = "SELECT g.id, g.title, n.order FROM tbl_general g INNER JOIN tbl_navigation n ON n.pageid = g.id WHERE n.type = '$_SESSION[parent]'"; $return = $database->query($q); while($row=mysql_fetch_assoc($return)){ $apageid[] = $row['id']; $apagename[] = $row['title']; $apageorder[] = $row['order']; } $count = count($pageid); $bpageid = array(); $bpageorder = array(); //run through each page one at a time and update the order of the menu for($i=0; $i++; $i<$count){ //set a few variables $pid = $pageid[$i]; $porder = $pageorder[$i]; ?> <select name="<?php $bpageid[$i] ?>"> <?php for($j=0; $j++; $j<$count){ ?> <option value="<?php $apageid[$j] ?>"><?php echo $apagename[$j]; ?></option> <?php } ?> </select> <select name="<?php $bpageorder[$i] ?>"> <?php for($j=0; $j++; $j<$count){ ?> <option value="<?php $apageorder[$j] ?>"><?php echo $apageorder[$j]; ?></option> <?php } ?> </select> <?php } ?> <input type="submit" name="navigation" value="Reorder pages" /> </form> </code></pre> <p>For example, if there were 7 menu items, the code should loop through all 7 and display 7 dropdown boxes each with the 7 options within. Next to each dropdown should be the numbers 1-7 which are the order of the boxes. This would allow each dropdown to pick a menu item and assign the order number to it.</p> <p>Of course, when the script is submitted, I'll validate that two items don't clash etc etc.</p> <p>The code currently isn't displaying anything but the submit button.</p> <p>Can anyone see the problem I have?</p> <p>Thanks</p>
Tags
<php><mysql>
Title
Reorder pages in a menu system
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USsark9012
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.