StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10897209
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-06-05T12:20:44.330
FavoriteCount
0
LastActivityDate
2012-06-05T12:20:44.330
LastEditDate
LastEditorUserId
0
OwnerUserId
1436266
ParentId
10896790
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I'd suggest simplifying your table a little bit, maybe taking the 'Displaying $numrows results' out of the table entirely. The line '<tr> Displaying $numrows results</tr>' is not valid HTML. <tr> means 'Define a new table row', but it needs a <td> inside it to wrap the content. Because most rows of your table contain several TD elements, whilst this row only contains one piece of information, you would need to tell that table cell to <a href="http://www.ironspider.ca/tables/tablecells2.htm" rel="nofollow">span multiple columns</a>. A good way of debugging this sort of thing is to feed the generated HTML to <a href="http://validator.w3.org/" rel="nofollow">http://validator.w3.org/</a>, or replace the $variables with sample data and feed the template code to a validator. This is usually a little frustrating at first (as it will force you to be exact about the HTML version you want to use, etc) but it is a good way of tracing problems. If you feed the following HTML snippet into the W3 validator, it will give you some useful feedback: <pre><code><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head><title>A</title></head> <body> <table><tr><td>aaa</td><td>bbb</td></tr> <tr><td>cccc</td><td>dddd</td></tr> <tr>Test</tr> </table> </body> </html> </code></pre> The validator tells you that: Line 7, Column 5: character data is not allowed here <pre><code><tr>Test</tr> </code></pre> In other words, the TR element should not directly contain text. It also says that: Line 7, Column 13: end tag for "tr" which is not finished <pre><code><tr>Test</tr> </code></pre> "Most likely, you nested tags and closed them in the wrong order... Another possibility is that you used an element which requires a child element that you did not include. Hence the parent element is "not finished", not complete. For instance, in HTML the <head> element must contain a <title> child element, lists require appropriate list items (<ul> and <ol> require <li> ...), and so on." Once you have the static HTML looking, and validating, the way you want, you can then add the PHP loops back in, but this time you can compare the script output to your working HTML example. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POdisplay php search results in html table
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USSoz
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. This table or related slice is empty.
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.