StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFetch specific field from a MySQL result array
primarykey
Id
1855993
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-12-06T17:39:38.643
FavoriteCount
0
LastActivityDate
2009-12-06T17:54:28.400
LastEditDate
2009-12-06T17:47:35.060
LastEditorUserId
53114
OwnerUserId
225877
ParentId
0
PostTypeId
1
Score
0
ViewCount
369
LastEditorDisplayName
text
Body
<p>I’m trying to retrive the field <em>media_file</em> from the first line of the query. I don’t figure how to do that. I’ve tried several times to get it by calling the multidimensional array <code>$pages[0]['media_file']</code> with no success.</p> <p>I’m trying to have the first image of a series bigger and then append the other thumbs. Here the page that we are talking about: <em><a href="http://www.svarnet.it/index.php?/works/svarnet-dream/" rel="nofollow noreferrer">http://www.svarnet.it/index.php?/works/svarnet-dream/</a></em></p> <p><strong>this is the code:</strong></p> <pre><code>function createExhibit() { $OBJ =& get_instance(); global $rs; $pages = $OBJ->db->fetchArray("SELECT * FROM ".PX."media, ".PX."objects_prefs WHERE media_ref_id = '$rs[id]' AND obj_ref_type = 'exhibit' AND obj_ref_type = media_obj_type ORDER BY media_order ASC, media_id ASC"); $s = "<div id='text-container'>\n"; $s .= $rs['content']; $s .= "</div>\n"; $s .= "\n<div class='cl'></div>\n"; if (!$pages) return $s; foreach ($pages as $height) { $height = getimagesize(DIRNAME . GIMGS . "/th-$height[media_file]"); $find_smallest_height[] = $height[1]; } sort($find_smallest_height, SORT_NUMERIC); rsort($find_smallest_height); $lowest = array_pop($find_smallest_height); $i = 1; $a = ''; foreach ($pages as $go) { $a .= "\n<a class='group' rel='group' href='" . BASEURL . GIMGS . "/$go[media_file]' title='$go[media_title]'><imgXXX src='" . BASEURL . GIMGS . "/th-$go[media_file]' alt='$go[media_caption]' height='80px' /></a>\n"; $i++; } // images $s .= "<div id='img-container'>\n"; // //////////////// HERE I WANT TO INSERT THE FIRST IMAGE OF THE QUERY $s .= "<imgXXX src='" . BASEURL . GIMGS . $pages['media_file'] . "' alt='$pages[media_title]' />"; // THEN APPEND THE OTHERS IN THUMB FORMAT $s .= $a; $s .= "</div>\n"; return $s; } </code></pre> <p>Thanks in advance!</p>
Tags
<php><mysql><fetch>
Title
Fetch specific field from a MySQL result array
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USGumbo
UserOwnerUserId
1. USiperdiscount
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
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.