StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGrabbing All of MYSQL Rows Using Array
primarykey
Id
17532457
data
AcceptedAnswerId
17532547
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-07-08T17:19:58.060
FavoriteCount
0
LastActivityDate
2013-07-08T17:38:13.287
LastEditDate
2013-07-08T17:38:13.287
LastEditorUserId
1599778
OwnerUserId
1599778
ParentId
0
PostTypeId
1
Score
0
ViewCount
73
LastEditorDisplayName
text
Body
<p>Hi I'm trying to output all of the rows and information from my table :</p> <p>id,Symbol,entry,<code>exit</code>,openclosed,entrydate,longshort,target_one,target_two,target_three,notes</p> <p>This is through this script I'm working on to get this functionality. Right now I'm only outputting one of the database entries. This entry of course being the last one. For reference the last entry symbol is GLD. I'd like it to continue with the next symbols, but can't seem to get it to output. The outputted data for quote_0,quote_1 ect. come from yahoo as an array. </p> <pre><code><?php error_reporting(E_ALL ^ E_NOTICE); ini_set("display_errors", 1); //begin include "storescripts/connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM stockpicks ORDER BY id LIMIT 100"); $productCount = mysql_num_rows($sql); // count the output amount if ($productCount > 0) { // get all the product details while($row = mysql_fetch_array($sql)){ $id = $row["id"]; $symbol = $row["symbol"]; } } mysql_close(); //end if(empty($symbol)) { echo nothing; } else { $open = fopen("http://quote.yahoo.com/d/quotes.csv?s=$symbol&f=sl1d1t1c1ohgv&e=.csv", "r"); $quote = fread($open, 1000); fclose($open); $quote = str_replace("\"", "", $quote); $quote = explode(",", $quote); $quote_0 = ($quote[0]); $quote_1 = ($quote[1]); $quote_2 = ($quote[2]); $quote_3 = ($quote[3]); $quote_4 = ($quote[4]); $quote_5 = ($quote[5]); $quote_6 = ($quote[6]); $quote_7 = ($quote[7]); $quote_8 = ($quote[8]); echo "<div class='symbol'><div class='quote'>Company: $quote_0</div></div>"; echo "<div class='leftofStocks'><div class='row'><div class='quote'>Last trade: $$quote_1</div>"; echo "<div class='quote'>Date: $quote_2</div>"; echo "<div class='quote'>Time: $quote_3</div>"; echo "<div class='quote'>From Previous: $$quote_4</div></div>"; echo "<div class='row'><div class='quote'>Open: $$quote_5</div>"; echo "<div class='quote'>High: $$quote_6</div>"; echo "<div class='quote'>Low: $$quote_7</div>"; echo "<div class='quote'>Volume: $quote_8</div></div>"; } ?> </code></pre>
Tags
<php><mysql><arrays>
Title
Grabbing All of MYSQL Rows Using Array
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHire Logo
UserOwnerUserId
1. USHire Logo
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
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POGrabbing All of MYSQL Rows Using Array
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId
1. COMysql is no longer used please use mysqli or pdo
  singulars
  PostPostId
  POGrabbing All of MYSQL Rows Using Array
  UserUserId
  This table or related slice is empty.
2. COTo clarify; php's mysql_ methods are deprecated and may no longer be supported in future versions of PHP. Use PDO or mysqli_ methods instead.
  singulars
  PostPostId
  POGrabbing All of MYSQL Rows Using Array
  UserUserId
  USStrawberry

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.