Evitar como se hace una consulta.

[alcapata]

<form action="insertar.php" method="post">



<table bgcolor="#CC9966"><tr><td>
Referencia &nbsp <input name="ref" type="text" size="5" maxlength="5"> &nbsp&nbsp
Tipo de Inmueble &nbsp <input type="text" name="tip" maxlength="20">&nbsp&nbsp
Gestion &nbsp <input name="gestion" type="text" size="10" maxlength="20">&nbsp&nbsp
Precio &nbsp <input name="prec" type="text" size="10" maxlength="20">
</td></tr></table>


<table bgcolor="#CC9966"><tr><td>
Zona &nbsp <input type="text" name="zona" maxlength="20">&nbsp&nbsp
Provincia &nbsp <input name="pro" type="text" size="10" maxlength="20">&nbsp&nbsp
Localidad &nbsp <input name="loca" type="text" size="10" maxlength="30">
</td></tr></table><br>

<table bgcolor="#CC9966"><tr><td>
Dormitorios&nbsp <input name="dor" type="text" size="2" maxlength="2"> &nbsp&nbsp
Baños&nbsp <input name="bañ" type="text" size="2" maxlength="2"> &nbsp&nbsp
Aseos&nbsp <input name="aseo" type="text" size="2" maxlength="2"> &nbsp&nbsp<br><br>
Superficie Construida &nbsp <input name="supe" type="text" size="7" maxlength="7"> &nbsp&nbsp
Parcela &nbsp <input name="parcela" type="text" size="7" maxlength="7"> &nbsp&nbsp
Antigüedad &nbsp <input name="antiguo" type="text" size="3" maxlength="2">
</td></tr></table>

<table bgcolor="#CC9966"><tr><td>

Cocina Amueblada&nbsp <input type="checkbox" name="cocina"><br>
Trastero&nbsp <input type="checkbox" name="trastero"><br>
Terraza&nbsp <input type="checkbox" name="terraza"><br>
Garaje&nbsp <input type="checkbox" name="garaje"><br>
Aire Acondicionado&nbsp <input type="checkbox" name="aire"><br>
Piscina&nbsp <input type="checkbox" name="piscina"><br>
Jardines&nbsp <input type="checkbox" name="jardines"><br>


</td></tr></table>

<table bgcolor="#CC9966"><tr><td>


Observaciones<blockquote><textarea name="obser"></textarea></blockquote>
</td></tr></table><hr>
<input type="submit" name="Enviar" value="Grabar" onClick="validar(this.form)"> &nbsp <input type="reset" value="Reestablecer"><a href="foto.php?id=<? echo $_POST[ref];?>">Agregar Foto</a><br>
<center><a href="editar.php">Volver</a></center>

<?php
//conexion
$host="localhost";
$root="root";
$pass="";
$bd="inmobiliaria";
$con=mysql_connect($host,$root,$pass) or die (mysql_error());
mysql_select_db($bd,$con) or die (mysql_error());

$refe=$_POST[ref];
$tipo=$_POST[tip];
$gestion=$_POST[gestion];
$precio=floatval($_POST[prec]);
$zona=$_POST[zona];
$provincia=$_POST[pro];
$localidad=$_POST[loca];
$dormi=$_POST[dor];
$baños=$_POST[bañ];
$aseos=$_POST[aseo];
$sup=$_POST[supe];
$parcela=$_POST[parcela];
$anti=$_POST[antiguo];
$obser=$_POST[obser];
$foto=$_POST[imagen];
if($_POST[Enviar]){
//consulta sql que es bastante larga

}

$r=mysql_query($sql,$con) or die (mysql_error());
echo "Se ha insertado otro registro!!!";




}

mysql_close($con);


?>

</form>
</body>
</html>