mysql - 从同一列中选择数据

Question

我需要从具有不同值的同一列中选择数据？我该怎么办

select * FROM billingorganization WHERE user_id = $user_id && user_id = 0?

<select name="billing_name">

<?php
    $query2 = "SELECT * from billingorganization WHERE user_id = $user_id";
    $result2 = mysqli_query($link, $query2) or die(mysqli_error($link));
    while ($row3 = mysqli_fetch_array($result2)) {
        $billing_name = $row3['billing_name'];
        $billing_name_id = $row3['billing_name_id'];

?>

     <option value="<?php echo $billing_name; ?>" ><?php echo $billing_name ;?></option>

<?php
     }
?>
</select>

Answer 1

select * FROM billingorganization WHERE user_id = $user_id OR user_id = 0