StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP+MySQL join statement arrange multiple values as row in mysql_fetch array
primarykey
Id
2238269
data
AcceptedAnswerId
2238402
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-02-10T16:03:16.803
FavoriteCount
0
LastActivityDate
2010-02-10T18:29:21.003
LastEditDate
2017-05-23T12:01:09.023
LastEditorUserId
-1
OwnerUserId
263501
ParentId
0
PostTypeId
1
Score
0
ViewCount
2728
LastEditorDisplayName
text
Body
<p>I am using a MySQL INNER JOIN statement which returns various results for one distinct record in the main table from the joins, similar to <a href="https://stackoverflow.com/questions/1038653/how-to-join-multiple-joins-yet-return-distinct-values">How to Join Multiple Joins yet return Distinct Values</a> My query is </p> <pre><code>SELECT cl.*, dep.dept_name FROM epapers.clientelle cl INNER JOIN epapers.dept_staff_users depu ON depu.user_id=cl.user_id INNER JOIN epapers.dept dep ON dep.dept_id=depu.dept_id group by cl.user_id ORDER BY cl.user_name ASC, </code></pre> <p>I would like to display the above in a table shown below</p> <pre><code>echo "<tr bgcolor='#CCCCCC'> <td >$num</td><td >".$row[user_id]."</td><td>".$row[user_name]."</td> <td >".$row[fname]."</td><td >".$row[lname]."</td> <td >".$row[dept_name]."</td> <td >".$row[dept_name]."</td> <td >".$row[dept_name]."</td> <td >".$row[email]."</td>"; $TrID = "$row[user_id]"; echo "<td >"; echo '<form name="activate" action="activate_acc.php" method="POST" ;">'; echo "<input type='hidden' name='TrID' value='$TrID'>"; echo "<input type='checkbox' name='active' value='$row[active]'>"; echo '<input type="submit" name="Submit" value="Delete">'; echo '</form>'; echo "</td >"; ... </code></pre> <p>Note the the departments can be upto 3 departments. How do I return the mysql query results in a single row for the departments?</p>
Tags
<php><mysql>
Title
PHP+MySQL join statement arrange multiple values as row in mysql_fetch array
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USDennis Kioko
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. 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.