php while loop not showing results

Question

Can someone please point out what I'm sure is a stupidly obvious error in my code? The string "string" in my while loop is displaying the correct amount of times but not the results in row[0].

if (!isset($_GET['city']) & !isset($_GET['county'])) {
    $getResults = "SELECT DISTINCT region FROM `locations` WHERE country = 'England'";
    echo "No region or county set";

    if ($result = $mysqli->query($getResults)) {
        echo "Found results";

        while ($row = $result->fetch_assoc()) {
            echo "string";
            echo $row[0];
        }
    }
}

In dubious cases, when something is not quite right, remember to use the var_dump() function to echo the variables in question... And then you save yourself valuable time figuring things like this out oon your own. — ppeterka
– ppeterka, Commented Sep 18, 2013 at 19:01
You're fetching assoc but trying to display as though the array is enumerated — Mark Baker
– Mark Baker, Commented Sep 18, 2013 at 19:02

Andy Bourassa · Accepted Answer · 2013-09-18 19:00:23Z

4

To see the contents of the $row array dump it out like so var_dump($row).

I'm guessing you just need echo $row['region'] rather than $row[0]

answered Sep 18, 2013 at 19:00

Andy Bourassa

1,8382 gold badges15 silver badges17 bronze badges

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

Comments

Sylver · Accepted Answer · 2013-09-18 19:05:31Z

2

You are using fetch_assoc() but you try to access the row using a index numbers.

Use fetch_row() instead.

answered Sep 18, 2013 at 19:05

Sylver

8,9586 gold badges41 silver badges55 bronze badges

Collectives™ on Stack Overflow

php while loop not showing results

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related