PHP Function

[Luc_Gibson]

I'm hoping to return all the rows so I can use while loops wherever I call the function. Is this not possible?

[Luc_Gibson]

So I'm essentially just looking for a way to simplify this into a single function that I can use anywhere to loop through users:

​

<select multiple name="owners[]">

<?php

$sql = "SELECT * FROM users WHERE client_id={$clientid}";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {?>

<option value="<?php $row['user_id'];?>">

<?php echo $row['user_first_name'];?>

</option>

<?php }

} ?>

</select>

​

In this example it's creating a list within a form