StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysql_query results in a while loop X 2
primarykey
Id
19527498
data
AcceptedAnswerId
19527615
AnswerCount
2
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-10-22T20:17:51.500
FavoriteCount
0
LastActivityDate
2013-10-22T20:25:15.510
LastEditDate
LastEditorUserId
0
OwnerUserId
2653988
ParentId
0
PostTypeId
1
Score
1
ViewCount
135
LastEditorDisplayName
text
Body
I am completely stumped here, Thanks in advance for any solutions or pointers, I really do appreciate any help you can offer. I am trying to make a memo system. Showing memo's is no problem but I am trying to only show the unread memo's. I have 2 tables as you can see, one that has the memo's and the other that lists the read memo's. when a user has read the memo's he/she ticks the box and the memo id and the user id is added to the table 'memo_read'. So basically I am trying to retrieve the memo's that have been read from the 'memo_read' table and then display the results from the 'memo' table that haven't been read where the user_id and the company are correct. As you can see I have 2 variables from a function on another page and these are working fine '$user_id , $company_id', I am trying to display the unread memo's in a while loop displaying the desired variables. I have been working on this for ages and no joy, I have tried every approach i can think of but i'm sure you can tell i'm not the most experienced of guys and i'm sure am have missed some thing or have taken the completely wrong approach! <pre><code><?php $user_id = $user_data['user_id'] ; $company_id = $user_data['company']; $result1 = mysql_query ("SELECT `user`, `memo_id` FROM`memo_read` WHERE `user`= '$user_id '") or die(mysql_error()); while($row = mysql_fetch_array($result1)){ $memo_id = $row['memo_id']; $result = mysql_query ("SELECT `id`, `link`, `author`, `time`, `title`, `company` FROM `memo` WHERE `worker`= 1 AND `company`= '$company_id' AND `id`!= '$memo_id'") or die(mysql_error()); while($row = mysql_fetch_array($result)) { $id = $row['id']; $link = $row['link']; $author = $row['author']; $time = $row['time']; $title = $row['title']; $company = $row['company']; ?> <ul> <li><?php echo $title; ?></li> <li><?php echo $author; ?></li> <li><?php echo $company;?></li> <li><?php echo $time;?></li> <a href="<?php echo $link; ?>"> Read memo</a> </ul> <?php } } ?> </code></pre>
Tags
<php><mysql><sql>
Title
mysql_query results in a while loop X 2
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. USRichard Harper
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
 POmysql_query results in a while loop X 2
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.