Jump to content

[SOLVED] Invalid argument supplied for foreach


heldenbrau

Recommended Posts

I get this error Warning: Invalid argument supplied for foreach() in /home/kangerc1/public_html/postonsuper.php on line 112for the following code:

 

$sortedvotes = sort($votecounter);
$smallcount=1;
foreach ($sortedvotes as $c){
  $sql="INSERT IF NOT EXISTS INTO supersum$casenum (field, votes) VALUES ($c,1)";
  if ($mysqli->query($sql)===true){
  }else{
    die("could not insert vote into supersum" . $mysqli->error);
  }
  if ($c==$foreachcounter){
    $smallcount++;
    $sql="UPDATE supersum$casenum votes='$smallcount'";;
  if ($mysqli->query($sql)===true){
  }else{
    die("could not insert vote into supersum" . $mysqli->error);
  }

  }else{
    $smallcount=1;
  }
  $foreachcount=$c;
}

 

Why am I getting this error?

sort does NOT return an array - it returns true or false...

 

<?php
sort($votecounter);
$smallcount=1;
foreach ($votecounter as $c){
  $sql="INSERT IF NOT EXISTS INTO supersum$casenum (field, votes) VALUES ($c,1)";
  if ($mysqli->query($sql)===true){
  }else{
    die("could not insert vote into supersum" . $mysqli->error);
  }
  if ($c==$foreachcounter){
    $smallcount++;
    $sql="UPDATE supersum$casenum votes='$smallcount'";;
  if ($mysqli->query($sql)===true){
  }else{
    die("could not insert vote into supersum" . $mysqli->error);
  }

  }else{
    $smallcount=1;
  }
  $foreachcount=$c;
}
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.