Código:
$sql='SELECT * FROM clientes WHERE 1=1'; $conexion= pg_connect ("host=localhost port=5432 user=postgres password=postgres dbname=Distribuidora_DC"); //abro la conexion if($codbuscar!=''){ $sql.=' and idcliente='. "'" .$codbuscar. "'"; } if($ape!=''){ $sql.=' and cli_ape='. "'" .$ape. "'"; } $result=pg_exec($conexion,$sql); echo "<table border=1 align=center bgcolor=white>\n"; echo "<tr><td>Código de Cliente</td><td>Nombre</td><td>Apellido</td><td>Domicilio</td><td>Teléfono</td><td>CUIT</td><td>E-mail</td><td>Idzona</td><td>Localidad</td><td>Provincia</td></tr>\n"; while($row=pg_fetch_row($result)){ echo "<tr><td>".$row[0]."</td><td>".$row[1]."</td><td>".$row[2]."</td><td>".$row[3]."</td><td>".$row[4]."</td><td>".$row[5]."</td><td>".$row[6]."</td><td>".$row[7]."</td><td>".$row[8]."</td><td>".$row[9]."</td></tr> \n"; //<td>".$row["fecha_sus"]."</td><td>".$row["direccion"]."</td></tr> \n"; } echo "</table>\n";