php while loop only displays one result for a mysql query across multiple tables

Question

I am having an issue with a while statement only returning one result. this is my first time trying to display product information from several tables and I don't know what I'm doing wrong. here is the code:

<?php
    require('./includes/config.inc.php');
    require(MYSQL);

    $sql = sprintf("SELECT * FROM tea");

    $res = mysqli_query($dbc, $sql);

    if(!$res){
    die('Could not complete query: '.mysqli_error($dbc));
    } else {

    echo 'Success!<br />';

    while($row = mysqli_fetch_array($res)){
        $table = $row['category'];
        $inum = $row['item_number'];

        echo $table.' '.$inum.'<br />';

        $fetch = sprintf("SELECT sub_category, item_name, description FROM $table WHERE item_number ='$inum'");
        $fetchRes = mysqli_query($dbc, $fetch);

        if(!$fetchRes){
            die('Could not fetch: '.mysqli_error($dbc));
        } else {
            while($fetchRow = mysqli_fetch_array($fetchRes)){
                $subCat = $fetchRes['sub_category'];
                $iNumber = $inum;
                $iname = $fetchRes['item_name'];
                $desc = $fetchRes['description'];

                echo $id.' '.$subCat.' '.$iNumber.' '.$iname.' '.$desc.'<br />';
            }
        }
    }
}

blearn · Accepted Answer · 2012-10-02 21:49:59Z

2

Inside your while loop, you should be using the $fetchRow variable as the array from which to grab columns, such as 'sub_category'.

answered Oct 2, 2012 at 21:49

blearn

1,21811 silver badges17 bronze badges

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

1 Comment

Michael Benavides Over a year ago

WOW don't know how I didn't notice that before... THANKS!

Case · Accepted Answer · 2012-10-02 21:52:34Z

0

IS

  $subCat = $fetchRes['sub_category'];
  $iNumber = $inum;
  $iname = $fetchRes['item_name'];
  $desc = $fetchRes['description'];

Needs to be: Res to Row

 $subCat = $fetchRow['sub_category'];
 $iNumber = $inum;
 $iname = $fetchRow['item_name'];
 $desc = $fetchRow['description'];

answered Oct 2, 2012 at 21:52

Case

4,2946 gold badges37 silver badges55 bronze badges

Collectives™ on Stack Overflow

php while loop only displays one result for a mysql query across multiple tables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related