StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTop 15 products, need a number to show for each one, starting with 1
primarykey
Id
9020569
data
AcceptedAnswerId
9027332
AnswerCount
3
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-01-26T15:33:02.837
FavoriteCount
0
LastActivityDate
2012-01-27T11:40:31.713
LastEditDate
2012-01-27T11:40:31.713
LastEditorUserId
390177
OwnerUserId
1171523
ParentId
0
PostTypeId
1
Score
1
ViewCount
156
LastEditorDisplayName
text
Body
<p>I'm creating a new website, I don't want to link direct to it so I'll put spaces inbetween: test . glow - sticks . org I have a list of the 15 most popular products on the right hand side of the page (WHATS HOT), I would like to show a number for each one, the first being 1 and the last being 15.</p> <p>I am a php noob, but despite reading about using range and foreach at the php manual site, I'm struggling to show numbers. I've found it easy to show the same range of numbers for each product block, e.g 1,2,3...15 showing 15 times, but this obviously isn't what I'm trying to do.</p> <p>I probably need to give more info than I have here, so I'll past the code that I'm working with on the php include:</p> <pre><code><div id="whatshot_smallblock"> <a href='/<?=str_replace(" ","-",$productname)?>.html'><img src='http://www.glow-sticks.org/images/products/<?=$productimage?>' alt='<?=$productname?>' width='66' height='66' hspace="2" vspace="2" border='0' class="radius" /> </a> <div id="whatshot_smallblock_Txt"> <a href='/<?=str_replace(" ","-",$productname)?>.html'><?=$productname?></a><br><div id="pink_color"><span class="content_2"><?=$minprice_dis?></span><?=$_SESSION['currsymbol']?><?=$minprice?></div></div> <div id="bigblacknumbers"></div></div> </code></pre> <p>and in my objectmanager php file I can see the code relating to the whatshot section:</p> <pre><code>//what's hot function whatshotids() { if( !isset( $this->dblink ) ) dbconnect(); //$sql = "SELECT COUNT(pid) AS repetitions, pid FROM gs_orderlines GROUP BY pid ORDER BY repetitions DESC LIMIT 15"; $timenow = time(); $checktime = ($timenow - 1814400); // 3 weeks $sql = "SELECT COUNT(pid) AS repetitions, gs_orderlines.pid FROM gs_orderlines INNER JOIN gs_orders ON gs_orders.oid = gs_orderlines.oid WHERE gs_orders.datetime >= $checktime GROUP BY gs_orderlines.pid ORDER BY repetitions DESC LIMIT 15"; $result = mysql_query( $sql, $this->dblink ) or die( "Invalid query Line 1018" ); $i = 0; $whids = array(); while( $row = mysql_fetch_object( $result ) ) { //// $sql2 = "SELECT * from gs_inventory WHERE pid = ".$row->pid. " AND display_product='1' AND stock>0 AND canbackstock!='yes'"; $result2 = mysql_query( $sql2, $this->dblink ); if($row2 = mysql_fetch_object( $result2 )){ $whids[$row->pid] = $row->repetitions; $i = $i + 1; } ... } ... } </code></pre> <p>Hopefully this is enough or too much information.</p> <p>Many thanks!</p>
Tags
<php><numbers><range>
Title
Top 15 products, need a number to show for each one, starting with 1
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCSchulz
UserOwnerUserId
1. USuser1171523
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
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POTop 15 products, need a number to show for each one, starting with 1
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POTop 15 products, need a number to show for each one, starting with 1
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId
1. COI dont see how the 2 pieces of code you have included work together ?
  singulars
  PostPostId
  POTop 15 products, need a number to show for each one, starting with 1
  UserUserId
  USManseUK

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.