My PHP MySQL while loop does not return results

Question

<?php
$sqls = mysql_query("SELECT weight FROM $usertablestats")
or die ("Query failed: " . mysql_error() . " Actual query: " . $query);
$ct = mysql_query ("COUNT * '$sqls'");

if ($ct > 0) {
   while ($row = mysql_fetch_array($sqls));{
      $weight = $row["weight"];
      echo "C" . $weight;
    }}
else {
  echo "No stats found";
}
?>

This outputs "No stats found" even though I have data in the table.

<?php
$sqls = mysql_query("SELECT weight FROM $usertablestats")
or die ("Query failed: " . mysql_error() . " Actual query: " . $query);
$ct = mysql_num_rows($sqls);

if ($ct > 0) {
   while ($row = mysql_fetch_array($sqls));{
      $weight = $row["weight"];
      echo "C" . $weight;
    }}
else {
  echo "No stats found";
}
?>

This returns nothing. No echo at all.

I have checked to see if it is accessing by just using:

<?php
   $sqls = mysql_query("SELECT weight FROM $usertablestats")
   or die ("Query failed: " . mysql_error() . " Actual query: " . $query);

   $row = mysql_fetch_array($sqls);

   echo $row;
?>

And it does return the first entry.

Sudhir Bastakoti · Accepted Answer · 2011-11-13 05:26:03Z

1

You have semicolon in while :

while ($row = mysql_fetch_array($sqls));{
//should be
while ($row = mysql_fetch_array($sqls)){

Is that causing problem

answered Nov 13, 2011 at 5:26

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

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

1 Comment

James AraSmith Over a year ago

//Thank you! I am new at this, and I knew it had to be something really stupid on my part. It worked great. I don't suppose there is a way to subtract the last row from the first?

dimme · Accepted Answer · 2011-11-13 05:26:01Z

0

Try this:

<?php
$sqls = mysql_query("SELECT weight FROM $usertablestats")
or die ("Query failed: " . mysql_error() . " Actual query: " . $query);

int $ct = 0;
while ($row = mysql_fetch_array($sqls)){
    $weight = $row["weight"];
    echo "C" . $weight;
    $ct++;
}

if ($ct == 0) {
    echo "No stats found";
}

?>

If it doesn't work then make sure that $usertablestats has the right value.

answered Nov 13, 2011 at 5:26

dimme

4,4344 gold badges33 silver badges50 bronze badges

Comments

Abhi Beckert · Accepted Answer · 2011-11-13 21:15:15Z

0

Try this.

while ($row = mysql_fetch_array($sqls,MYSQL_ASSOC)){
    $weight = $row["weight"];
    echo "C" . $weight;
    $ct++;
}

edited Nov 13, 2011 at 21:15

Abhi Beckert

33.5k12 gold badges89 silver badges115 bronze badges

answered Nov 13, 2011 at 7:14

no_freedom

1,97110 gold badges30 silver badges48 bronze badges

Comments

vickyqiu · Accepted Answer · 2013-08-23 09:23:06Z

0

<?php
$sqls = mysql_query("SELECT * FROM $usertablestats")
or die ("Query failed: " . mysql_error() . " Actual query: " . $query);

if (mysql_num_rows($sqls)!=0) {
   while ($row = mysql_fetch_assoc($sqls)){
   $weight = $row["weight"];
   echo "C" . $weight;
}}
else {
   echo "No stats found";
}
?>

answered Aug 23, 2013 at 9:23

vickyqiu

9,4993 gold badges15 silver badges4 bronze badges

Collectives™ on Stack Overflow

My PHP MySQL while loop does not return results

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related