StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POis there a simpler way to write this so the latest entry shows and not previous entries?
primarykey
Id
19416350
data
AcceptedAnswerId
19416510
AnswerCount
1
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-10-17T00:39:12.143
FavoriteCount
0
LastActivityDate
2013-10-17T01:05:07.893
LastEditDate
LastEditorUserId
0
OwnerUserId
2827550
ParentId
0
PostTypeId
1
Score
0
ViewCount
45
LastEditorDisplayName
text
Body
<pre><code>if ($row['note_1'] !== '' && $row['note_2'] == '' && $row['note_3'] == '' && $row['note_4'] == '' && $row['note_5'] == '' && $row['note_6'] == '') { echo $row['note_1_user'].": "; echo $row['note_1']; } if ($row['note_1'] !== '' && $row['note_2'] !== '' && $row['note_3'] == '' && $row['note_4'] == '' && $row['note_5'] == '' && $row['note_6'] == '') { echo $row['note_2_user'].": "; echo $row['note_2']; } if ($row['note_1'] !== '' && $row['note_2'] !== '' && $row['note_3'] !== '' && $row['note_4'] == '' && $row['note_5'] == '' && $row['note_6'] == '') { echo $row['note_3_user'].": "; echo $row['note_3']; } if ($row['note_1'] !== '' && $row['note_2'] !== '' && $row['note_3'] !== '' && $row['note_4'] !== '' && $row['note_5'] == '' && $row['note_6'] == '') { echo $row['note_4_user'].": "; echo $row['note_4']; } if ($row['note_1'] !== '' && $row['note_2'] !== '' && $row['note_3'] !== '' && $row['note_4'] !== '' && $row['note_5'] !== '' && $row['note_6'] == '') { echo $row['note_5_user'].": "; echo $row['note_5']; } if ($row['note_1'] !== '' && $row['note_2'] !== '' && $row['note_3'] !== '' && $row['note_4'] !== '' && $row['note_5'] !== '' && $row['note_6'] !== '') { echo $row['note_6_user'].": "; echo $row['note_6']; } </code></pre> a table with 6 note fields and 6 note user field for a total of 12 fields dealing with notes. there are other fields, but the notes fields are 12. in the add note page it's only possible to write to one set at a time. when going to the page the first time, they add note to field note_1 and the username automatically goes into note_1_user. then the second time going to the page, the note will go into note_2, and the user automatically goes into note_2_user. previous notes do not get over-written. i have a page to view all notes, however, on a different page i just want the latest note to show up. i can't think of a better way to make that happen other than the way i posted above. basically every if statement is the same. they all have the same 6 checks, checking if there is data in the fields, except the first one is checking if one of the 6 is not empty, then the second one checks if two are not empty, and so forth until the last one checks if all 6 are not empty. this seems like too much code to do this effect.
Tags
<php><mysql><sql>
Title
is there a simpler way to write this so the latest entry shows and not previous entries?
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. USleoarce
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

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.