I made a query
where I got the result of this query, however what I need is this result shows only one line, a single record but in reality I have more than one: follow the code below and please show me where I'm going wrong because I can not see the error or the lack of some element ..
if (empty($_POST['contrato'])) {"";}
if(isset($_POST['contrato'])) {"";
if($_POST['contrato'] == "") {"";}
else{
$cmd = "SELECT login FROM tecnicos GROUP BY Area = '%$Roteamento%' ";
$login_tecnico = mysqli_query($conn, $cmd);
$row = mysqli_num_rows($login_tecnico);
if($row == " ") {" ";} else{
while ($res = mysqli_fetch_array($login_tecnico)) {
$tec_login = $res['login'];
Successfully displays the tec_loogin
variable, but as I said this displays only 1 record when it actually has more than one, my question is how to display all of them ?? help me ...