Can I select values from one column in an php-array? [duplicate]

Question

I need only the values of one column in an array. Without php I would use "SELECT valueX FROM tableY". This does not work with php. I only get one result. This is what I have:

$salty = "SELECT salt FROM login";
$salts = mysqli_query($connection, $salty);
$validsalts = mysqli_fetch_array($salts);

you can use loop [while loop for example] to get multiple records while($validsalts = mysqli_fetch_array($salts)){} — Mittul Chauhan
– Mittul Chauhan, Commented Aug 10, 2016 at 8:54

Dhaval Purohit · Accepted Answer · 2016-08-10 08:54:20Z

1

You have to make a loop iteration for fetching the all value.

for example.

$salty = "SELECT salt FROM login";
$salts = mysqli_query($connection, $salty);
while($validsalts = mysqli_fetch_array($salts))
{
    echo $validsalts['salt'];
}

answered Aug 10, 2016 at 8:54

Dhaval Purohit

1,29011 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Can I select values from one column in an php-array? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related