Why does php fetches data from table at random?

Asked Jun 07 '21 at 15:31

Active Jun 07 '21 at 15:31

Viewed 23 times

I am trying to fetch the values of a column in PHP and I am not sure why it is fetched at random. In the table, they are ordered from 1 to 5 and when I echo I get 14253. I have a similar function for another column and it works great, same as this one. Did I do something wrong?

public function getSKUProducts() {
        $sql = "SELECT SKU FROM Product_table";
        $stmt = $this->connect()->query($sql);
        $array = Array();
        //get data from db
        while($row = $stmt->fetch_assoc()) {
            echo $row['SKU'];
            $array[] =  $row['SKU'];  
        }
        return $array;
    }

asked Jun 07 '21 at 15:31

Stephano.

2

Use `Order By COLUMN_NAME` in your query. – Hackinet Jun 07 '21 at 15:33
2

That's just SQL behaviour. There is no inherent ordering, you have to use explicit ordering if you want to ensure you will get them in the same order every time. – El_Vanja Jun 07 '21 at 15:34
@Hackinet I feel so dumb, thanks a lot. Do you know why is it happening just for this column tho? – Stephano. Jun 07 '21 at 15:36
@El_Vanja thanks for explaining! – Stephano. Jun 07 '21 at 15:37

Why does php fetches data from table at random?

0 Answers0