getting rows from database with php - nothing returned

Question

So here is my php code:

$result = mysqli_query($con, "SELECT * FROM WW_temp");
$numrows = mysqli_num_rows($result);

if ($numrows!=0){
    while ($row = mysqli_fetch_assoc($result) && $numOfPics >= 1){
        $ImageFilename = $row["image"];
        echo "$ImageFilename///";
    $numOfPics--;
    }
}

The output I am getting is ///////// (9 '/') when numOfPics is set to 3. There is definitely some fields in the column 'image' in the database. Is there anything wrong with the code?

try to dump your row to see what's in it (var_dump($row)); this should help you (and us) figure out what's wrong. Maybe also add a sample of the WW_temp table so we can get a better idea. — Gorkk
– Gorkk, Commented Feb 25, 2014 at 21:58

Sammitch · Accepted Answer · 2014-02-25 22:02:22Z

2

You logic is squiffy. Currently your while condition is interpreted as:

$row = (mysqli_fetch_assoc($result) && $numOfPics >= 1)

So $row == true while there are rows and $numOfPics >= 1.

Change it to:

while ( ($row = mysqli_fetch_assoc($result)) && $numOfPics >= 1 ){

and it should behave sane-ly.

answered Feb 25, 2014 at 22:02

Sammitch

32.5k7 gold badges58 silver badges92 bronze badges

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

Collectives™ on Stack Overflow

getting rows from database with php - nothing returned

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related