StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to Remove PHP Array Implode Character from Beginning of String
primarykey
Id
8994018
data
AcceptedAnswerId
9023532
AnswerCount
5
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-01-24T20:55:30.610
FavoriteCount
0
LastActivityDate
2012-01-26T18:44:31.270
LastEditDate
LastEditorUserId
0
OwnerUserId
967773
ParentId
0
PostTypeId
1
Score
0
ViewCount
1080
LastEditorDisplayName
text
Body
<p>I am working on a project that requires imploding an array with character separation. I have successfully used <code>join</code> and <code>implode</code> interchangeably in other parts of the project, but I can't get it to work in this section. </p> <pre><code>$dbQuery = "SELECT ftc.*, fc.name FROM facilities f LEFT JOIN facility_to_category ftc ON f.fid = ftc.fid LEFT JOIN facility_categories fc ON ftc.cid = fc.cid WHERE f.listing_year = '2011' AND fc.parent_cid = '2' AND f.fid = ('".$listing_fid."')"; $dbResult = $dbc->query($dbQuery,__FILE__,__LINE__); $num_results = $dbc->num_rows($dbResult); echo '<h3>Demographics</h3> <div>'; while($catdata = $dbc->fetch($dbResult)) { $demographics = array(); $demographic_names = array('',trim($catdata->name)); $demographics = implode(' '.chr(149).' ',$demographic_names); print $demographics; } </code></pre> <p>The result is this: </p> <pre><code>Demographics • Affluent • Children • Hard-to-Reach • Parents </code></pre> <p>instead of </p> <pre><code>Demographics Affluent • Children • Hard-to-Reach • Parents </code></pre> <p>I've tried using double quotes instead of single quotes around '.chr(149).'. I've tried using commas or bars or just spaces. I've tried different ways of trimming and not trimming <code>$catdata->name</code>. </p> <p>I also thought about trying string concatenation, but then I'll end up with an extra character at the end instead of the beginning. <code>Implode</code> or <code>join</code> seem the better way to go.</p> <p>What am I missing?</p>
Tags
<php><arrays><implode>
Title
How to Remove PHP Array Implode Character from Beginning of String
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USdeewilcox
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. This table or related slice is empty.
CommentsPostId
1. COIs `$demographic_names[0]` blank? Also, why are you setting `$demographics = array();` then almost immediately turning it into a string?
  singulars
  PostPostId
  POHow to Remove PHP Array Implode Character from Beginning of String
  UserUserId
  USMatt H

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.