Databases
StackOverflow2013
Postsdbo
POPHP show values of associative array when one of the values equals a specified value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP show values of associative array when one of the values equals a specified value
    primarykey
    data
    text
    <p>I have a Mysql Recordset that I have put into an associative array so that I can reuse it over and over.</p> <p>I used this function to put the values into the array:</p> <pre><code>while(($Comments[] = mysql_fetch_assoc($rsComments)) || array_pop($Comments)); </code></pre> <p>Here is what the print_r($Comments) displays</p> <pre><code>Array ( [0] =&gt; Array ( [CommentID] =&gt; 10 [Comment] =&gt; Ouch [CommentAuthor] =&gt; Randy Krohn [CommentDate] =&gt; 2010-10-06 17:19:49 [ID] =&gt; 1231 [CategoryID] =&gt; 42 ) [1] =&gt; Array ( [CommentID] =&gt; 12 [Comment] =&gt; This is the Dirty Duck [CommentAuthor] =&gt; John Lemoine [CommentDate] =&gt; 2010-10-06 17:22:43 [ID] =&gt; 1411 [CategoryID] =&gt; 42 ) [2] =&gt; Array ( [CommentID] =&gt; 13 [Comment] =&gt; Talk about deja vu! [CommentAuthor] =&gt; dber [CommentDate] =&gt; 2010-10-06 17:24:48 [ID] =&gt; 1473 [CategoryID] =&gt; 42 ) ) </code></pre> <p>I am looping through a list of images, and I want to display only the comments associated with an images specified ImageID (for example 1473).</p> <p>I need to display only the ones where the ID is equal to a specified value?</p> <p>This must be easy, but for some reason, it is just flying over my head.</p> <p>Thanks for you help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPekka 웃
    1. USdragboatrandy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload