StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPut text news into a box?
primarykey
Id
10633462
data
AcceptedAnswerId
10633684
AnswerCount
1
ClosedDate
2012-05-17T21:47:47.150
CommentCount
23
CommunityOwnedDate
CreationDate
2012-05-17T09:57:59.193
FavoriteCount
0
LastActivityDate
2012-05-17T11:14:23.567
LastEditDate
2012-05-17T10:55:26.903
LastEditorUserId
1261597
OwnerUserId
1261597
ParentId
0
PostTypeId
1
Score
0
ViewCount
573
LastEditorDisplayName
text
Body
<p>on <a href="http://www.youngcreativity.se" rel="nofollow">http://www.youngcreativity.se</a></p> <p>you can se that it is a news feed. </p> <p>Is it possible to when a user upload a news, all the texts/news beeing shown in like a rounded box? The box should auto resize after how many news there are in the feed. The php code looks like this.</p> <pre><code><!DOCTYPE html> <html lang='en'> <head> <style type="text/css"> #boxID{ border:2px solid; border-radius:25px; width:auto; height:auto; } element { color: black; } body { -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; background-attachment: fixed; background-image: url(bgn1.png); background-repeat: no-repeat; background-position: center top; } .news { font-family: Rough_Typewriter; font-size: 36px; } </style> <meta charset="UTF-8"> <title>iWrite</title> <meta name="view" content="width-device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="keywords" content=""> <link href="css/bootstrap.css" rel="stylesheet"> </head> <h1 class="news">iWrite</h1> <p> <hr> <p> <p> <p> <p> <p> <p> <p> <p> <p> <a href='post.php'>Want to post a text?</a> <?php //connect mysql_connect("server","username","password") or die(mysql_error()); mysql_select_db("database") or die(mysql_error()); //query the database $getnews = mysql_query("SELECT * FROM news ORDER BY id DESC") or die(mysql_query()); while ($row = mysql_fetch_assoc($getnews)) { //get data $id = $row['id']; $title = $row['title']; $body = $row['body']; $date = $row['date']; echo " <b>$title posted on $date</b><br> "; echo nl2br($body); echo "<hr> "; } mysql_real_escape_string(); ?> </hr></html> </code></pre>
Tags
<css>
Title
Put text news into a box?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UStracifycray
UserOwnerUserId
1. UStracifycray
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
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. VO
  singulars
  PostPostId
  POPut text news into a box?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
2. VO
  singulars
  PostPostId
  POPut text news into a box?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POPut text news into a box?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTModeratorReview
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.