Avoid duplicate field of BD PHP

Question

Avoid duplicate field of BD PHP

Navigation

#1 by (0 votes)

0

I have a table in the Database where I have repeated fields and blank fields. And I must show the results without repetitions and without empty fields.

I have worked on the following code, which so far does:

for($nombres=array();$row=sqlsrv_fetch_array($res_fact);$nombres[$row['CRAZONSOCIAL']]=$row['CRAZONSOCIAL']){
				
				if(!$nombres[$row['CRAZONSOCIAL']] && $row['CRAZONSOCIAL'] != '' ){
			?>
					<tr>
					<td><?php echo $row['CRAZONSOCIAL'] ?></td>
					<td><?php echo $row['CFOLIO'] ?></td>
					</tr>
			<?php
				}
			}

It has no problems except that I get the following:

> Notice: Undefined index: TELCEL in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: MOVISTAR SA DE CV in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: GLOBOSYSTEM in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: VENDEDOR 1 in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: PROVEEDOR 1 in C:\xampp\htdocs\practica\w_facturas.php on line 37

Notice: Undefined index: proveedor prueba in C:\xampp\htdocs\practica\w_facturas.php on line 37

Line 37 would come with this:



    if(!$nombres[$row['CRAZONSOCIAL']] && $row['CRAZONSOCIAL'] != '' ){

Any ideas?

sql php

asked by Checo 12.04.2017 в 21:29

source

1 answer

Check username already registered Firebase Android error when installing sql server 2008 express on a virtual machine

score 0 · Accepted Answer

I've already managed to solve it, I'll leave it in case the same thing happens to someone.

for($nombres=array();$row=sqlsrv_fetch_array($res_fact);$nombres[$row['CRAZONSOCIAL']]=$row['CRAZONSOCIAL'])
				$variable = isset($nombres[$row['CRAZONSOCIAL']]) ? $nombres[$row['CRAZONSOCIAL']] : null ;
				if(!$variable && $row['CRAZONSOCIAL'] != '' ){
			?>
					<tr>
						<td><?php echo $row['CRAZONSOCIAL'] ?></td>
						<td><?php echo $row['CRAZONSOCIAL'] ?></td>
					</tr>
			<?php
				}
			}