PHP fetching array inside an array

Question

while($row = mysqli_fetch_array($getCropsInvestor)){
        $cropID = $row['CropID'];
        $selectCrop = mysqli_query($con, "SELECT * FROM Crops WHERE ID=$cropID");
        $fetchCropData = mysqli_fetch_array($selectCropData,MYSQLI_ASSOC);
        if($fetchCropData){
            echo 'Suc';
        }
        else{
            echo 'Fail';
        }
        $checkAvail = $fetchCropData['Availability'];

Can someone explain to me why this code returns Fail
and a solution on how to achieve this goal.

Sougata Bose · Accepted Answer · 2017-02-06 12:15:04Z

3

The query result stored in $selectCrop.

$selectCropData should be $selectCrop.

$fetchCropData = mysqli_fetch_array($selectCrop,MYSQLI_ASSOC);..

answered Feb 6, 2017 at 12:15

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

2 Comments

Gilbert Mendoza Over a year ago

oh damn how can i be so dense. i didn't even notice that. i though fetching array inside a fetch is unavailable. thank you for this. i'll accept this after 10 mins

Sougata Bose Over a year ago

I would suggest you to use JOINs if possible.

Dario · Accepted Answer · 2017-02-06 12:52:39Z

0

When Query Executed

$selectCrop = mysqli_query($con, "SELECT * FROM Crops WHERE ID=$cropID");

this result is stored in $selectCrop so use $selectCrop instead of $selectCropData in mysqli_fetch_array

$fetchCropData = mysqli_fetch_array(**$selectCrop**,MYSQLI_ASSOC);

Thats all .... Happy coding

edited Feb 6, 2017 at 12:52

Dario

6,3109 gold badges42 silver badges53 bronze badges

answered Feb 6, 2017 at 12:23

Muhammad Farhan

14 bronze badges

1 Comment

Muhammad Farhan Over a year ago

I suggest yo to use PDO to handle these errors better

Collectives™ on Stack Overflow

PHP fetching array inside an array

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related