<Select id="dt" name="catagory" class="catagory" onchange "circular()" required="required"> <option value="">Date</option> <?php require('db.php'); $sql = mysqli_query($conn,

Question

<Select id="dt" name="catagory" class="catagory" onchange "circular()" required="required"> <option value="">Date</option> <?php require('db.php'); $sql = mysqli_query($conn,

"SELECT circularno, date,cir content, heading From circular");
$row =mysqli_num_rows ($sql);
while ($row = mysqli_fetch_array($sql)){
echo "<option value-='". $row['date']."'>" .$row['date']."</option>" ;
}? >
</select>
<select id="circ" name="category 1" class="category1" required="required">
<option value=" ">Circular Number</option>
<?php

require('db.php');

$sql = mysqli_query ($Con, "SELECT circularno From circular");
$row= mysqli_num_rows ($sql);
while ($row = mysql_fetch_array($sql)){

echo "<option value='".$row[' circularno']."'>" .$row[' circularno']."</option>";

0

09.02.2020

4 ответов

10 просмотров

Пользователь 63431 Автор вопроса

This is what currently used for judt pick the data of a single column and show it in dropdown

0

09.02.2020

Fakhzan

Yes, this will be rendered once. If you want to change the rendered document, you need to do it via Javascript or reload the page with a variable set that will render it differently (for example as a GET parameter)

0

09.02.2020

Lympri Nyyminen

use pdo

0

09.02.2020

Haider · Accepted Answer

Haider

Only have to do require('db.php') once btw

0

09.02.2020

Похожие чаты

<Select id="dt" name="catagory" class="catagory" onchange "circular()" required="required"> <option value="">Date</option> <?php require('db.php'); $sql = mysqli_query($conn,

4 ответов

Похожие вопросы