使用php在dropdownlist中的两个不同表中显示值

Question

I have two database tables, released_movies and upcoming_movies. I need to display the field rel_movies in release_movies table and up_movies field in upcoming_movies table inside a single dropdown list. Below is my code.

<select name="film" class="form-control">
<?php
include "connection.php";
$sql="select rel_movies from released_movies";
$sqlr=$con->query($sql);
while($row=$sqlr->fetch_assoc())
{
?>
<option value="<?php echo $row['rel_movies'];?>"><?php echo $row['rel_movies'];?></option>
<?php
}
?>
</select>

I have no idea how to display up_movies field into it. Is this possible .Thanks in advance.

Answer 1

Try this

    <?php include "connection.php"; ?>
    <select name="film" class="form-control">
    <?php
        $sqlr="select rel_movies from released_movies";
        $sqlrr=$con->query($sqlr);
        while($row=$sqlrr->fetch_assoc()) { ?>
    <option value="<?php echo $row['rel_movies'];?>">
<?php echo $row['rel_movies'];?>
</option>
    <?php }
        $sqlu="select up_movies from upcoming_movies";
        $sqluu=$con->query($sqlu);
        while($rowu=$sqluu->fetch_assoc()){ ?>
    <option value="<?php echo $rowu['up_movies'];?>">
<?php echo $rowu['up_movies'];?>
</option>
    <?php } ?>
    </select>