我想选择1列MySQL表行

Question

I have a made a MySQL table, and I've been trying to make it answer on my site. As for now, it picks all the columns in my rows, and I wanted to pick a specific column.

Does anyone know a better way to make it echo on your page?

<?php
$data = "SELECT * FROM anmeldelser";

$result = $connection->query($data);



while($row = $result->fetch_array()){

    echo "<b>Kundenavn:&nbsp;</b>" . $row['Kundenavn'] . "<b>&nbsp;Kommentar:&nbsp;</b>" . $row['Kommentar'] . "<b>&nbsp;Dato:&nbsp;</b>" . $row['Dato'];

}

?>`

This gives the result of every row in my db. I want to pick one random or just be specific about which one I want to place in which div.

Thanks in advance.

Answer 1

i found a solution myself.

$data = "SELECT * FROM mytabel WHERE name = 'Steve'";

To select the next, you copy the line and type the next name of your tabel.

$data = "SELECT * FROM mytabel WHERE name = 'Bob'";

Which makes it echo only one of the columns.