StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
primarykey
Id
4148714
data
AcceptedAnswerId
4155701
AnswerCount
4
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-11-10T20:22:57.127
FavoriteCount
0
LastActivityDate
2010-11-30T11:32:17.087
LastEditDate
2010-11-10T20:24:27.893
LastEditorUserId
187606
OwnerUserId
484338
ParentId
0
PostTypeId
1
Score
3
ViewCount
294
LastEditorDisplayName
text
Body
<p>The following statement is returning a 1 in php. I've serialized and output the result and every other credential, and it is doing this on three seperate queries. When I run the query in sqlpro or phpmyadmin I get the result as 8. Please tell me someone has a bright idea.</p> <pre><code>$numRFPsSwitch = 0; $bquery = " SELECT COUNT(rp.id) AS 'NumRFPs' FROM rfp_proposal rp WHERE rp.vendor_id = 1 AND rp.id IN(13,15,16,23,24,26,4,9) "; $bresult = mysql_query($bquery, $connection); $XMLFormatedString .= 'NumRFPs="'; while ($brow = mysql_fetch_object($bresult)){ $XMLFormatedString .= $brow->NumRFPs; $numRFPsSwitch = 1; } </code></pre>
Tags
<php><mysql>
Title
php mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPekka 웃
UserOwnerUserId
1. USnone
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. VO
  singulars
  PostPostId
  POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COCould you add the part where you output the variable that gives you the 1?
  singulars
  PostPostId
  POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
  UserUserId
  USJasper De Bruijn
2. COIf you could post the details about the output of a var_dump of the row object it may shed some light
  singulars
  PostPostId
  POphp mysql result coming back wrong, every time from php, but is fine in sql pro and phpmyadmin
  UserUserId
  USPayload

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.