require ("open_db_prod.php" ); if ( isset( $idp ) ) { $res = @mysql_query( "SELECT p.cprod, p.descr, p.precioVenta1, i.tipo AS iva, p.notas, p.fabricante, p.garantia, p.imgH, p.imgW FROM productos AS p, tipos_iva AS i WHERE p.id=$idp AND i.id=p.tipo_iva",$conexion_prod ) or die(mysql_error($conexion_prod)); if ( @mysql_num_rows($res)>0 ) { list( $db_cprod, $db_descr, $db_pv, $db_iva, $db_notas, $db_fabr, $db_gar, $db_imgH, $db_imgW ) = @mysql_fetch_array( $res ); echo "
". "
". "
$db_descr
". "
"; echo "
Código:
$db_cprod". "
Precio:
$db_pv €". "
IVA:
$db_iva". "
Garantía:
$db_gar meses". "
Fabricante:
$db_fabr
"; echo "
"; if ( $db_imgH > 0 ) { echo '
'; } echo "
"; echo "
Notas:
".nl2br($db_notas)."
"; } } mysql_free_result($res); mysql_close($conexion); function resize($H, $W) { $nW = 200; $nH = 200; $image_prop = ""; if ( $W > 0 ) { if ( !($W < $nW ||$H < $nH ) ) { if ( $W > $H ) { $nH = intval(($H/$W)*$nW); $image_prop = " width=\"$nW\" height=\"".$nH."\""; } else { $nW = intval(($W/$H)*$nH); $image_prop = " height=\"$nH\" width=\"".$nW."\""; } } else { $image_prop=" width=\"$W\" height=\"$H\""; } } return $image_prop; } ?>