Why would this Count create two of each?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

Why would this Count create two of each?

Post by simonmlewis »

Code: Select all

    
$primaryromancode = isset($_POST['primaryromancode']) ? $_POST['primaryromancode'] : null;
  $romancode1 = isset($_POST['romancode1']) ? $_POST['romancode1'] : null;
  $romancode2 = isset($_POST['romancode2']) ? $_POST['romancode2'] : null;
  $romancode3 = isset($_POST['romancode3']) ? $_POST['romancode3'] : null;
  $romancode4 = isset($_POST['romancode4']) ? $_POST['romancode4'] : null;
  $romancode5 = isset($_POST['romancode5']) ? $_POST['romancode5'] : null;
  $romancode6 = isset($_POST['romancode6']) ? $_POST['romancode6'] : null;
  $romancode7 = isset($_POST['romancode7']) ? $_POST['romancode7'] : null;
  $romancode8 = isset($_POST['romancode8']) ? $_POST['romancode8'] : null;
  $romancode9 = isset($_POST['romancode9']) ? $_POST['romancode9'] : null;
  $romancode10 = isset($_POST['romancode10']) ? $_POST['romancode10'] : null;
  $romancode11 = isset($_POST['romancode11']) ? $_POST['romancode11'] : null;
  $romancode12 = isset($_POST['romancode12']) ? $_POST['romancode12'] : null;

$count = 0;
    $countcodes = 0;
    while ($count <= 11)
      {
      $count ++;
      echo "<font color='#ff0000'>$count</font>";
      $romancodefind = ${'romancode' . $count};
      $query = "SELECT title, photoprimary, price, romancode FROM products WHERE romancode =:romancodefind";
      $result = $pdo->prepare($query);
      $result->execute(array(':romancodefind' => $romancodefind));
      while ($row = $result->fetch(PDO::FETCH_OBJ)) 
        { 
        echo "<div style='width: 20%; float: left'><img src='/images/productphotos/$row->photoprimary' style='width: 100%' />$row->title<br/>$row->price<Br/>($romancodefind)</div>";
      $countcodes ++;
        }
        echo "<font color='#ff0000'>$count</font>";
      }
This is giving me most strange results.
We are creating bundles of products, so we are posting up to 12 store codes, and a primary code. Hitting save.
Then it turns over, and shows you each product that has been saved.

But this is producing loads of them, and I cannot see why.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

Re: Why would this Count create two of each?

Post by simonmlewis »

Got the answer. The fields were posting blanks, and there are some blank fields in our database. So it was just pulling up the products (Test ones), that had blanks in them.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
Post Reply