sum(value) gives undefined index
0
I'm having trouble calculating the sum of one column in the database from the first 5 rows. My code is:
$mysqli=mysqli_connect($host,$user,$password,$database);
$sql = "SELECT SUM(medie) FROM (SELECT medie FROM stelewar WHERE nume='".$nume."' ORDER BY id DESC LIMIT 5) medie";
$result=mysqli_query($mysqli,$sql);
$row=mysqli_fetch_assoc($result);
$sumamedie= $row["medie"];
The last row of code throws the error "Undefined index: medie" and I cannot figure out why...
Any thoughts?
php mysql
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
|
show 4 more comments
0
I'm having trouble calculating the sum of one column in the database from the first 5 rows. My code is:
$mysqli=mysqli_connect($host,$user,$password,$database);
$sql = "SELECT SUM(medie) FROM (SELECT medie FROM stelewar WHERE nume='".$nume."' ORDER BY id DESC LIMIT 5) medie";
$result=mysqli_query($mysqli,$sql);
$row=mysqli_fetch_assoc($result);
$sumamedie= $row["medie"];
The last row of code throws the error "Undefined index: medie" and I cannot figure out why...
Any thoughts?
php mysql
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
try doingvar_dump($row)before the last line and check to see what the index the expected data is in. i don't believe the index for theSUM(medie)field of your row is going to bemedie
– Memor-X
Oct 12 '16 at 23:47
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
1
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
3
TrySELECT SUM(medie) as medie FROM
– RiggsFolly
Oct 12 '16 at 23:53
WARNING: When usingmysqliyou should be using parameterized queries andbind_paramto add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put$_POSTor$_GETdata directly into a query, it can be very harmful if someone seeks to exploit your mistake.
– tadman
Oct 13 '16 at 1:34
|
show 4 more comments
0
0
0
I'm having trouble calculating the sum of one column in the database from the first 5 rows. My code is:
$mysqli=mysqli_connect($host,$user,$password,$database);
$sql = "SELECT SUM(medie) FROM (SELECT medie FROM stelewar WHERE nume='".$nume."' ORDER BY id DESC LIMIT 5) medie";
$result=mysqli_query($mysqli,$sql);
$row=mysqli_fetch_assoc($result);
$sumamedie= $row["medie"];
The last row of code throws the error "Undefined index: medie" and I cannot figure out why...
Any thoughts?
php mysql
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
I'm having trouble calculating the sum of one column in the database from the first 5 rows. My code is:
$mysqli=mysqli_connect($host,$user,$password,$database);
$sql = "SELECT SUM(medie) FROM (SELECT medie FROM stelewar WHERE nume='".$nume."' ORDER BY id DESC LIMIT 5) medie";
$result=mysqli_query($mysqli,$sql);
$row=mysqli_fetch_assoc($result);
$sumamedie= $row["medie"];
The last row of code throws the error "Undefined index: medie" and I cannot figure out why...
Any thoughts?
php mysql
php mysql
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
asked Oct 12 '16 at 23:46
ggcristianggcristian
1
1
try doingvar_dump($row)before the last line and check to see what the index the expected data is in. i don't believe the index for theSUM(medie)field of your row is going to bemedie
– Memor-X
Oct 12 '16 at 23:47
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
1
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
3
TrySELECT SUM(medie) as medie FROM
– RiggsFolly
Oct 12 '16 at 23:53
WARNING: When usingmysqliyou should be using parameterized queries andbind_paramto add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put$_POSTor$_GETdata directly into a query, it can be very harmful if someone seeks to exploit your mistake.
– tadman
Oct 13 '16 at 1:34
|
show 4 more comments
try doingvar_dump($row)before the last line and check to see what the index the expected data is in. i don't believe the index for theSUM(medie)field of your row is going to bemedie
– Memor-X
Oct 12 '16 at 23:47
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
1
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
3
TrySELECT SUM(medie) as medie FROM
– RiggsFolly
Oct 12 '16 at 23:53
WARNING: When usingmysqliyou should be using parameterized queries andbind_paramto add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put$_POSTor$_GETdata directly into a query, it can be very harmful if someone seeks to exploit your mistake.
– tadman
Oct 13 '16 at 1:34
try doing
var_dump($row) before the last line and check to see what the index the expected data is in. i don't believe the index for the SUM(medie) field of your row is going to be medie– Memor-X
Oct 12 '16 at 23:47
try doing
var_dump($row) before the last line and check to see what the index the expected data is in. i don't believe the index for the SUM(medie) field of your row is going to be medie– Memor-X
Oct 12 '16 at 23:47
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
1
1
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
3
3
Try
SELECT SUM(medie) as medie FROM– RiggsFolly
Oct 12 '16 at 23:53
Try
SELECT SUM(medie) as medie FROM– RiggsFolly
Oct 12 '16 at 23:53
WARNING: When using
mysqli you should be using parameterized queries and bind_param to add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put $_POST or $_GET data directly into a query, it can be very harmful if someone seeks to exploit your mistake.– tadman
Oct 13 '16 at 1:34
WARNING: When using
mysqli you should be using parameterized queries and bind_param to add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put $_POST or $_GET data directly into a query, it can be very harmful if someone seeks to exploit your mistake.– tadman
Oct 13 '16 at 1:34
|
show 4 more comments
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
});
}
});
draft saved
draft discarded
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%2f40010095%2fsumvalue-gives-undefined-index%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
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f40010095%2fsumvalue-gives-undefined-index%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
try doing
var_dump($row)before the last line and check to see what the index the expected data is in. i don't believe the index for theSUM(medie)field of your row is going to bemedie– Memor-X
Oct 12 '16 at 23:47
Query is most likely failing or no rows returned, etc.
– Darren
Oct 12 '16 at 23:48
1
You've aliased the subquery the same as the column you want to SUM
– jakub wrona
Oct 12 '16 at 23:52
3
Try
SELECT SUM(medie) as medie FROM– RiggsFolly
Oct 12 '16 at 23:53
WARNING: When using
mysqliyou should be using parameterized queries andbind_paramto add user data to your query. DO NOT use string interpolation or concatenation to accomplish this because you have created a severe SQL injection bug. NEVER put$_POSTor$_GETdata directly into a query, it can be very harmful if someone seeks to exploit your mistake.– tadman
Oct 13 '16 at 1:34