validação

[nandojlle 0]

To tentando fazer uma validação de cnpj no meu formulario de cadastro, pra q caso o cnpj ja exista ele emita um aviso de erro.

 

como estou usando o dreamweaver pra fazer um insert no banco estou um pouco confuso, pois ele usa o script de insert na msm pagina do formulario.

 

fiz um include da validação na pagina de formulario.

o que esta errado???

 

 

pagina verificacnpj.php

 

<?php require_once('Connections/corretor.php'); ?><?php$colname_validaCNPJ = "1";if (isset($_POST['CNPJID'])) {  $colname_validaCNPJ = (get_magic_quotes_gpc()) ? $_POST['CNPJID'] : addslashes($_POST['CNPJID']);}mysql_select_db($database_corretor, $corretor);$query_validaCNPJ = sprintf("SELECT * FROM cadastro WHERE cot_cnpj = '%s'", $colname_validaCNPJ);$validaCNPJ = mysql_query($query_validaCNPJ, $corretor) or die(mysql_error());$row_validaCNPJ = mysql_fetch_assoc($validaCNPJ);$totalRows_validaCNPJ = mysql_num_rows($validaCNPJ);?><?php if (!empty($row_validaCNPJ['cot_cnpj'])){print "<script> alert('CNPJ ja cadsatrodo!');</script>";}?><?mysql_free_result($validaCNPJ);?>

cadastro de clientes...

cadastro.php

 

<?php require_once('Connections/corretor.php'); ?><?php include ("verifica.php"); ?><?php include ("men_abertos.php"); ?><?php include ("men_fechados.php"); ?><?php include ("men_cancelados.php"); ?><?php include ("men_corretores.php"); ?><?php include ("men_paraorcar.php"); ?><?php $sx = $_GET['nv']; ?><?php  include ("verifica.php");include ("verificacnpj.php");?><?php session_start();$nv = $_SESSION['nv'];$s = "$s";$id = $_SESSION['id']; ?><?phpfunction GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;  switch ($theType) {    case "text":      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";      break;        case "long":    case "int":      $theValue = ($theValue != "") ? intval($theValue) : "NULL";      break;    case "double":      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";      break;    case "date":      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";      break;    case "defined":      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;      break;  }  return $theValue;}$editFormAction = $_SERVER['PHP_SELF'];if (isset($_SERVER['QUERY_STRING'])) {  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);}if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {include ("verificacnpj.php");  $insertSQL = sprintf("INSERT INTO cadastro (cot_empresa, cot_razaosocial, cot_contato, cot_cidade, cot_fone, cot_email, cot_cnpj, cot_rua, cot_numero, cot_cep, cot_obs, cot_data, cot_codproduto, cor_comresp) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",                       GetSQLValueString($_POST['nome'], "text"),                       GetSQLValueString($_POST['razao'], "text"),                       GetSQLValueString($_POST['contato'], "text"),                       GetSQLValueString($_POST['cidade'], "text"),                       GetSQLValueString($_POST['fone'], "text"),                       GetSQLValueString($_POST['email'], "text"),                       GetSQLValueString($_POST['CNPJID'], "text"),                       GetSQLValueString($_POST['rua'], "text"),                       GetSQLValueString($_POST['numero'], "text"),                       GetSQLValueString($_POST['comercialresp'], "text"),                       GetSQLValueString($_POST['cep'], "text"),                       GetSQLValueString($_POST['obs'], "text"),                       GetSQLValueString($_POST['hiddenField'], "date"),                       GetSQLValueString($_POST['comercialresp'], "int"));  mysql_select_db($database_corretor, $corretor);  $Result1 = mysql_query($insertSQL, $corretor) or die(mysql_error());  $insertGoTo = "orcamentocadcor.php?nv=" . $_SESSION['nv'] . "&id=" . $_SESSION['id'] . "";  if (isset($_SERVER['QUERY_STRING'])) {    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";    $insertGoTo .= $_SERVER['QUERY_STRING'];  }  header(sprintf("Location: %s", $insertGoTo));}$colname_Recordset1 = "-1";if (isset($_SESSION['id'])) {  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_SESSION['id'] : addslashes($_SESSION['id']);}mysql_select_db($database_corretor, $corretor);$query_Recordset1 = sprintf("SELECT * FROM equipe WHERE equi_codigo = '%s'", $colname_Recordset1);$Recordset1 = mysql_query($query_Recordset1, $corretor) or die(mysql_error());$row_Recordset1 = mysql_fetch_assoc($Recordset1);$totalRows_Recordset1 = mysql_num_rows($Recordset1);?><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><title>Untitled Document</title><script language="JavaScript" type="text/JavaScript"><!--function MM_reloadPage(init) {  //reloads the window if Nav4 resized  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();}MM_reloadPage(true);//--></script><script language="JavaScript" type="text/javascript"> function carregar(){ var url; url = 'verificacnpj.php?CNPJID='+document.form1.CNPJID.value; location = url; } function inicia() { var CPF1; CPF1 = myIframe.loc; if (CPF1!="Nao") { alert("CPF já existe na base de dados!"); } } </script> <script language="JavaScript">  <!--  function isNum( caractere )  {  var strValidos = "0123456789"  if ( strValidos.indexOf( caractere ) == -1 )  return false;  return true;  }  function validaTecla(campo, event)  {  var BACKSPACE= 8;  var key;  var tecla;   CheckTAB=true;  if(navigator.appName.indexOf("Netscape")!= -1)  tecla= event.which;  else  tecla= event.keyCode;   key = String.fromCharCode( tecla);  //alert( 'key: ' + tecla + ' -> campo: ' + campo.value);   if ( tecla == 13 )  return false;  if ( tecla == BACKSPACE )  return true;  return ( isNum(key));  }   function FormataCNPJ( el )  {  vr = el.value;  tam = vr.length;   if ( vr.indexOf(".") == -1 )  {  if ( tam <= 2 )  el.value = vr;  if ( (tam > 2) && (tam <= 6) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, tam );  if ( (tam >= 7) && (tam <= 10) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, 3 ) + '.' + vr.substr( 5, 3 ) + '/';  if ( (tam >= 11) && (tam <= 18) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, 3 ) + '.' + vr.substr( 5, 3 ) + '/' + vr.substr( 8, 4 ) + '-' + vr.substr( 12, 2 );  }  return true; } //--> </script> <script language="JavaScript">  <!--  function isNum( caractere )  {  var strValidos = "0123456789"  if ( strValidos.indexOf( caractere ) == -1 )  return false;  return true;  }  function validaTecla(campo, event)  {  var BACKSPACE= 8;  var key;  var tecla;   CheckTAB=true;  if(navigator.appName.indexOf("Netscape")!= -1)  tecla= event.which;  else  tecla= event.keyCode;   key = String.fromCharCode( tecla);  //alert( 'key: ' + tecla + ' -> campo: ' + campo.value);   if ( tecla == 13 )  return false;  if ( tecla == BACKSPACE )  return true;  return ( isNum(key));  }   function FormataCNPJ( el )  {  vr = el.value;  tam = vr.length;   if ( vr.indexOf(".") == -1 )  {  if ( tam <= 2 )  el.value = vr;  if ( (tam > 2) && (tam <= 6) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, tam );  if ( (tam >= 7) && (tam <= 10) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, 3 ) + '.' + vr.substr( 5, 3 ) + '/';  if ( (tam >= 11) && (tam <= 18) )  el.value = vr.substr( 0, 2 ) + '.' + vr.substr( 2, 3 ) + '.' + vr.substr( 5, 3 ) + '/' + vr.substr( 8, 4 ) + '-' + vr.substr( 12, 2 );  }  return true; } //--> </script> <script language="Javascript">function entsub(event){//Internet Explorerif(window.event && window.event.keyCode == 13){return false;}//Netscape e Mozillaif (event && event.which == 13){return false;}}</script><script language="Javascript"><!--function validaCNPJ() {  CNPJ = document.validacaob.CNPJID.value;  erro = new String;  if (CNPJ.length < 18) erro += "E' necessarios preencher corretamente o numero do CNPJ! \n\n";  if ((CNPJ.charAt(2) != ".") || (CNPJ.charAt(6) != ".") || (CNPJ.charAt(10) != "/") || (CNPJ.charAt(15) != "-")){ 	 if (erro.length == 0) erro += "E' necessarios preencher corretamente o numero do CNPJ! \n\n";  }  //substituir os caracteres que nao sao numeros  if(document.layers && parseInt(navigator.appVersion) == 4){ 	 x = CNPJ.substring(0,2); 	 x += CNPJ.substring(3,6); 	 x += CNPJ.substring(7,10); 	 x += CNPJ.substring(11,15); 	 x += CNPJ.substring(16,18); 	 CNPJ = x;	  } else { 	 CNPJ = CNPJ.replace(".",""); 	 CNPJ = CNPJ.replace(".",""); 	 CNPJ = CNPJ.replace("-",""); 	 CNPJ = CNPJ.replace("/","");  }  var nonNumbers = /\D/;  if (nonNumbers.test(CNPJ)) erro += "A verificacao de CNPJ suporta apenas numeros! \n\n";	  var a = [];  var b = new Number;  var c = [6,5,4,3,2,9,8,7,6,5,4,3,2];  for (i=0; i<12; i++){ 	 a[i] = CNPJ.charAt(i); 	 b += a[i] * c[i+1];  }  if ((x = b % 11) < 2) { a[12] = 0 } else { a[12] = 11-x }  b = 0;  for (y=0; y<13; y++) { 	 b += (a[y] * c[y]);   }  if ((x = b % 11) < 2) { a[13] = 0; } else { a[13] = 11-x; }  if ((CNPJ.charAt(12) != a[12]) || (CNPJ.charAt(13) != a[13])){ 	 erro +="Digito verificador com problema!";  }  if (erro.length > 0){ 	 alert(erro); 	 return false;  } else { 	 alert("CNPJ valido!");  }  return true;	}function MM_findObj(n, d) { //v4.01  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);  if(!x && d.getElementById) x=d.getElementById(n); return x;}function YY_checkform() { //v4.66//copyright (c)1998,2002 Yaromat.com  var args = YY_checkform.arguments; var myDot=true; var myV=''; var myErr='';var addErr=false;var myReq;  for (var i=1; i<args.length;i=i+4){    if (args[i+1].charAt(0)=='#'){myReq=true; args[i+1]=args[i+1].substring(1);}else{myReq=false}    var myObj = MM_findObj(args[i].replace(/\[\d+\]/ig,""));    myV=myObj.value;    if (myObj.type=='text'||myObj.type=='password'||myObj.type=='hidden'){      if (myReq&&myObj.value.length==0){addErr=true}      if ((myV.length>0)&&(args[i+2]==1)){ //fromto        var myMa=args[i+1].split('_');if(isNaN(myV)||myV<myMa[0]/1||myV > myMa[1]/1){addErr=true}      } else if ((myV.length>0)&&(args[i+2]==2)){          var rx=new RegExp("^[\\w\.=-]+@[\\w\\.-]+\\.[a-z]{2,4}$");if(!rx.test(myV))addErr=true;      } else if ((myV.length>0)&&(args[i+2]==3)){ // date        var myMa=args[i+1].split("#"); var myAt=myV.match(myMa[0]);        if(myAt){          var myD=(myAt[myMa[1]])?myAt[myMa[1]]:1; var myM=myAt[myMa[2]]-1; var myY=myAt[myMa[3]];          var myDate=new Date(myY,myM,myD);          if(myDate.getFullYear()!=myY||myDate.getDate()!=myD||myDate.getMonth()!=myM){addErr=true};        }else{addErr=true}      } else if ((myV.length>0)&&(args[i+2]==4)){ // time        var myMa=args[i+1].split("#"); var myAt=myV.match(myMa[0]);if(!myAt){addErr=true}      } else if (myV.length>0&&args[i+2]==5){ // check this 2            var myObj1 = MM_findObj(args[i+1].replace(/\[\d+\]/ig,""));            if(myObj1.length)myObj1=myObj1[args[i+1].replace(/(.*\[)|(\].*)/ig,"")];            if(!myObj1.checked){addErr=true}      } else if (myV.length>0&&args[i+2]==6){ // the same            var myObj1 = MM_findObj(args[i+1]);            if(myV!=myObj1.value){addErr=true}      }    } else    if (!myObj.type&&myObj.length>0&&myObj[0].type=='radio'){          var myTest = args[i].match(/(.*)\[(\d+)\].*/i);          var myObj1=(myObj.length>1)?myObj[myTest[2]]:myObj;      if (args[i+2]==1&&myObj1&&myObj1.checked&&MM_findObj(args[i+1]).value.length/1==0){addErr=true}      if (args[i+2]==2){        var myDot=false;        for(var j=0;j<myObj.length;j++){myDot=myDot||myObj[j].checked}        if(!myDot){myErr+='* ' +args[i+3]+'\n'}      }    } else if (myObj.type=='checkbox'){      if(args[i+2]==1&&myObj.checked==false){addErr=true}      if(args[i+2]==2&&myObj.checked&&MM_findObj(args[i+1]).value.length/1==0){addErr=true}    } else if (myObj.type=='select-one'||myObj.type=='select-multiple'){      if(args[i+2]==1&&myObj.selectedIndex/1==0){addErr=true}    }else if (myObj.type=='textarea'){      if(myV.length<args[i+1]){addErr=true}    }    if (addErr){myErr+='* '+args[i+3]+'\n'; addErr=false}  }  if (myErr!=''){alert('The required information is incomplete or contains errors:\t\t\t\t\t\n\n'+myErr)}  document.MM_returnValue = (myErr=='');}//--></script><style type="text/css"><!--.fundo {	overflow-x: hidden;   }body{	overflow-x: hidden;	SCROLLBAR-FACE-COLOR: #F2F2F2;	SCROLLBAR-HIGHLIGHT-COLOR: #F2F2F2;	SCROLLBAR-SHADOW-COLOR: #F2F2F2;	SCROLLBAR-3DLIGHT-COLOR: #F2F2F2;	SCROLLBAR-ARROW-COLOR: #4F88AD;	SCROLLBAR-TRACK-COLOR: #FFFFFF;	SCROLLBAR-DARKSHADOW-COLOR: #F2F2F2;	}.fonte {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 12px;	color: #455C81;}.formula2 {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 10px;	background-color: #FAFAF5;	border: 1px solid #A0B1C5;	color: #006699;}.style1 {	font-size: 11px;	font-family: Verdana, Arial, Helvetica, sans-serif;	color: #006699;}.textoage {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 11px;	color: 669966;}.textto {	font-size: 10px;	font-family: Verdana, Arial, Helvetica, sans-serif;}.txtgrande {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 14px;	font-weight: bold;	font-variant: normal;	text-transform: none;}.style2 {color: #455C81; font-family: Verdana, Arial, Helvetica, sans-serif;}.style3 {font-family: Verdana, Arial, Helvetica, sans-serif}.style4 {font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif;}.styleb {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 11px;	color: #FF6600;}.formula21 {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 11px;	background-color: #F4FAFB;	border: 1px solid #82ADC0;	color: #006699;}.textto1 {font-size: 11px;}--></style><STYLE TYPE='text/css'><!-- TextRollover-1 -->a:link { color:#006699; text-decoration:none}a:visited { color:#006699; text-decoration:none}a:hover { color:#FF6600; text-decoration:underline; cursor:hand}a:active { color:#006699; text-decoration:none}</STYLE></head><body class="fundo"><div id="Layer5" style="position:absolute; left:221px; top:14px; width:113px; height:23px; z-index:5"><img src="imagens/titorcamento.gif" width="295" height="25"></div><div id="Layer6" style="position:absolute; left:228px; top:62px; width:519px; height:60px; z-index:6;" class="fonte">  <table width="505" border="0" cellspacing="0" cellpadding="0">    <tr bgcolor="#FF6600">      <td width="28"><font color="#FFFFFF"><strong><img src="imagens/sdnr1.gif" width="20" height="22" align="absmiddle"> <span class="style4"></span></strong></font></td>      <td width="477"><font color="#FFFFFF"><strong><span class="style4">Cadastrar novo Cliente</span></strong></font></td>    </tr>    <tr>      <td colspan="2"><img src="imagens/transparent.gif" width="10" height="3"></td>    </tr>    <tr>      <td> </td>      <td><form action="<?php echo $editFormAction; ?>" method="POST" name="form1" onSubmit="YY_checkform('form1','nome','#q','0','Campo \'Nome da Empresa\' inválido','razao','#q','0','Campo \'Razão Social\' inválido','CNPJID','#q','0','Campo \'CNPJID\' inválido','contato','#q','0','Campo \'contato\' inválido','email','S','2','Campo \'email\' inválido','cidade','#q','0','Campo \'cidade\' inválido','comercialresp','#q','0','Campo \'comercial responsável\' inválido');return document.MM_returnValue">        <table width="468" border="0" align="left" cellpadding="0" cellspacing="0">          <tr>            <td colspan="2"><font color="#6D492E" size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/transparent.gif" width="7" height="10"></font></td>          </tr>          <tr>            <td width="4"> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Nome da Empresa</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="nome" type="text" class="formula21" id="nome" size="55">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Razão Social</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="razao" type="text" class="formula21" id="razao" size="55">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>C.N.P.J.</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">            <input name="CNPJID" type="text" class="formula21" id="CNPJID" onBlur="FormataCNPJ(this);" onKeyPress="return validaTecla(this, event)" size="35" maxlength="18"></font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Contato</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="contato" type="text" class="formula21" id="contato" size="35">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>e-mail</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="email" type="text" class="formula21" id="email" size="35">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Rua</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="rua" type="text" class="formula21" id="rua" size="35">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Número</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="numero" type="text" class="formula21" id="numero" size="15">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>CEP</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="cep" type="text" class="formula21" id="cep" size="15">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Cidade</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="cidade" type="text" class="formula21" id="cidade" size="35">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Fone</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <input name="fone" type="text" class="formula21" id="fone" size="35" maxlength="20">            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="9"></font></td>          </tr>          <tr>            <td> </td>            <td><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif" class="textto1"><strong>Observações</strong></font></td>          </tr>          <tr>            <td> </td>            <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">              <textarea name="obs" cols="52" rows="4" wrap="VIRTUAL" class="formula21" id="obs"></textarea>            </font></td>          </tr>          <tr>            <td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/linhacot.gif" width="336" height="13"></font></td>          </tr>          <tr>            <td colspan="2"><?php echo $_SERVER['PHP_SELF'] ?> </td>          </tr>          <tr>            <td> </td>            <td valign="bottom"><div align="left"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <br>                      <input name="Submit" type="submit" class="formula21" value="Confirmar Cadastro" onClick="return Verificar();">                      <input name="hiddenField" type="hidden" value="<?php echo date("Y-m-d g:i:s "); ?>">                      <input name="comercialresp" type="hidden" id="comercialresp" value="<?php echo $row_Recordset1['equi_codigo']; ?>">                      </font></div></td>          </tr>          <tr>            <td colspan="2"><div align="right"><font color="#6D492E" size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="imagens/transparent.gif" width="7" height="20"></font></div></td>          </tr>        </table>        <input type="hidden" name="MM_insert" value="form1">      </form></td>    </tr>  </table></div></body></html><?phpmysql_free_result($Recordset1);?>

[wolfphw 60]

Cara você pode fazer o seguinte... coloca seu codigo pra procurar se jah existe o CNPJ antes da linha do insert dele..... dai você faz o seguinte... colcoa dentro de um IF se ele achar ele manda o aviso senaum ee insere...