Printing entire column from mysql using while loop

Question

I am trying to print the all of the contents in column1 (Filename) in mysql database, however, only the first row is being printed. I believe this is solved by using while loop in order to print the whole contents in that column. However I cannot get it to work.

I have tried:

while($row = mysql_fetch_array($result))

but it didn't work

This is the script that works but only prints the top row:

<?php
$servername = "localhost";
$user = "xxxx";
$password = "xxxx";
$dbname = "123";

// Create connection
$conn = mysqli_connect($servername, $user, $password, $dbname);

if (!$conn)
{
die("Connection failed: " . mysqli_connect_error());
}

$query = "SELECT Filename FROM Test";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_array($result);
$Filename[] = $row['Filename'];

echo $row['Filename'];

mysqli_close($conn);
?>

Vivek Singh · Accepted Answer · 2015-06-29 12:35:25Z

2

you were not using while loop in proper way try this & use the data wherever you want

while($row = mysqli_fetch_array($result))
{
//$Filename[] = $row['Filename'];

//echo $row['Filename']."<br/>";

echo $row[0];
}

answered Jun 29, 2015 at 12:35

Vivek Singh

2,4451 gold badge16 silver badges29 bronze badges

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

Comments

Amrut Gaikwad · Accepted Answer · 2015-06-29 12:51:19Z

1

Use this:

while($row = mysqli_fetch_array($result))
{
     $Filename[] = $row['Filename'];
}

answered Jun 29, 2015 at 12:51

Amrut Gaikwad

5521 gold badge4 silver badges19 bronze badges

Collectives™ on Stack Overflow

Printing entire column from mysql using while loop

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