PHP variable not displaying value

Question

I am storing MySQL Query value in PHP variable, but its not displaying data. P.S: Data is available in MySQL table column.

 <?php 
$cmsca= mysql_query("SELECT SUM(qa_effort) FROM tbl_uat WHERE product='CAP'");
     while ($cresulta = mysql_fetch_array ($cmsca)) 
         $arra[0] = $cresulta[0];
         echo $arra[0];
?>

I am out of clues, what is wrong in above code? Need help!

Regards

have you tried using var_dump($cresulta[0]); to see what's in there ? Sometimes echo fail displaying some values (like false) — pomeh
– pomeh, Commented Oct 9, 2013 at 10:59
Please make sure your query returns the result, otherwise you are doing right. — Subedi Kishor
– Subedi Kishor, Commented Oct 9, 2013 at 11:00

echo_Me · Accepted Answer · 2013-10-09 11:11:49Z

5

try this

   <?php 
  $cmsca= mysql_query("SELECT SUM(qa_effort) as sums FROM tbl_uat WHERE product='CAP'");
   while ($cresulta = mysql_fetch_array($cmsca)) 
   {
     echo $cresulta['sums'];
   }
  ?>

edited Oct 9, 2013 at 11:11

answered Oct 9, 2013 at 10:58

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ekramul Hoque Over a year ago

Answer is ok but explanation makes a answer better +1.

echo_Me Over a year ago

@Farhad the reality is i dont know what to explain :) , this basic, he is mixing between mysql_fetch_array and mysql_fetch_num .

pomaxa · Accepted Answer · 2013-10-09 11:03:41Z

-1

first of all, do not use mysql_query, - it's deprecated, use http://www.php.net/manual/en/mysqli.query.php instead. Next, you need to connect to the db, before running query;

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

$result = mysqli->query("SELECT SUM(qa_effort) as sums FROM tbl_uat WHERE product='CAP'");
while ($row = $result->fetch_array()) {
    var_dump($row);
}

$mysqli->close();
?>

answered Oct 9, 2013 at 11:03

pomaxa

1,74616 silver badges26 bronze badges

Comments

Al3x_F4nt0m · Accepted Answer · 2013-10-09 11:04:12Z

-1

How about trying this:

<?php
 $arra = array(); 
 $cmsca= mysql_query("SELECT SUM(qa_effort) FROM tbl_uat WHERE product='CAP'");
 while ($row = mysql_fetch_array ($cmsca)) 
     $arra = $row;
     print_r($arra);
 ?>

answered Oct 9, 2013 at 11:04

Al3x_F4nt0m

462 bronze badges

Collectives™ on Stack Overflow

PHP variable not displaying value

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related