Mixing
How to get top most liked post among my all post from mysql using PHP
As per the below code status='notlove' shows that the user already liked, and status='love' indicated that user liked it and again unlike this post,
The Qus is, the code gives me the proper result but when i liked a new post,
it is not showing me the proper result, instead of showing most liked post it is showing me the New Post result, How can i solve this Issue?
Kindly refer my Table View also
I'm getting the user which is logged in
$id = $_SESSION["id"];
//query for getting the top most timeline id of current log in user
$sql= "SELECT *
FROM lovetimeline
INNER JOIN (
SELECT userId, MAX(timelineId) AS Maxscore
FROM lovetimeline
GROUP BY userId
) topscore
ON lovetimeline.ownerId = '$id'
AND status='notlove'
AND lovetimeline.timelineId = topscore.maxscore";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
//getting the top liked post from table
$_SESSION["toppost"] = $row["timelineId"];
}
php
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
add a comment |
As per the below code status='notlove' shows that the user already liked, and status='love' indicated that user liked it and again unlike this post,
The Qus is, the code gives me the proper result but when i liked a new post,
it is not showing me the proper result, instead of showing most liked post it is showing me the New Post result, How can i solve this Issue?
Kindly refer my Table View also
I'm getting the user which is logged in
$id = $_SESSION["id"];
//query for getting the top most timeline id of current log in user
$sql= "SELECT *
FROM lovetimeline
INNER JOIN (
SELECT userId, MAX(timelineId) AS Maxscore
FROM lovetimeline
GROUP BY userId
) topscore
ON lovetimeline.ownerId = '$id'
AND status='notlove'
AND lovetimeline.timelineId = topscore.maxscore";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
//getting the top liked post from table
$_SESSION["toppost"] = $row["timelineId"];
}
php
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11
add a comment |
As per the below code status='notlove' shows that the user already liked, and status='love' indicated that user liked it and again unlike this post,
The Qus is, the code gives me the proper result but when i liked a new post,
it is not showing me the proper result, instead of showing most liked post it is showing me the New Post result, How can i solve this Issue?
Kindly refer my Table View also
I'm getting the user which is logged in
$id = $_SESSION["id"];
//query for getting the top most timeline id of current log in user
$sql= "SELECT *
FROM lovetimeline
INNER JOIN (
SELECT userId, MAX(timelineId) AS Maxscore
FROM lovetimeline
GROUP BY userId
) topscore
ON lovetimeline.ownerId = '$id'
AND status='notlove'
AND lovetimeline.timelineId = topscore.maxscore";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
//getting the top liked post from table
$_SESSION["toppost"] = $row["timelineId"];
}
php
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
As per the below code status='notlove' shows that the user already liked, and status='love' indicated that user liked it and again unlike this post,
The Qus is, the code gives me the proper result but when i liked a new post,
it is not showing me the proper result, instead of showing most liked post it is showing me the New Post result, How can i solve this Issue?
Kindly refer my Table View also
I'm getting the user which is logged in
$id = $_SESSION["id"];
//query for getting the top most timeline id of current log in user
$sql= "SELECT *
FROM lovetimeline
INNER JOIN (
SELECT userId, MAX(timelineId) AS Maxscore
FROM lovetimeline
GROUP BY userId
) topscore
ON lovetimeline.ownerId = '$id'
AND status='notlove'
AND lovetimeline.timelineId = topscore.maxscore";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
//getting the top liked post from table
$_SESSION["toppost"] = $row["timelineId"];
}
php
php
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
edited Jan 2 at 9:19
RiggsFolly
71.8k1867113
71.8k1867113
asked Jan 2 at 9:03
sid itssid its
12
asked Jan 2 at 9:03
sid itssid its
12
asked Jan 2 at 9:03
sid itssid its
12
12
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11
add a comment |
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003622%2fhow-to-get-top-most-liked-post-among-my-all-post-from-mysql-using-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003622%2fhow-to-get-top-most-liked-post-among-my-all-post-from-mysql-using-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
pls do add the database tables and explain better
– spartyboy
Jan 2 at 9:08
inner join should be between 2 tables what it means ? topscore ON lovetimeline.ownerId = '$id' ? why $id? it must be like lovetimeline.ownerId = topscore.ownerId & also you need to select ownderId for subquery part tooo
– Sayed Mohd Ali
Jan 2 at 9:12
Thank you Sayed Mohd Ali Sir for the help
– sid its
Jan 6 at 19:11