hola a todos buscando y buscando no consigo la forma de hacer lo siguiente: tengo un BD de registro por supuesto este me registra la fecha gringa 000-00-00 bien ahora lo que solicito es que cuando uno de los registrados ingrese a su login le traiga la fecha en español 00-00-0000, la fecha en mi tabla la tengo con nombre FECHA
usuario.php:
Código PHP:
<?php
include('../imagen/ln.php');
mysql_connect("localhost","XXXXX","XXXXX") ;
mysql_select_db("sedemat");
$C=mysql_query("SELECT * FROM vehiculoj WHERE patente=".$_POST["PATENTE"]);
if ($R=mysql_fetch_array($C))
{
}
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Liquidacion de Patente de Vehiculo</title>
</head>
<body topmargin="7" leftmargin="0">
<table border="0" width="612" id="table1" cellspacing="1" cellpadding="0" height="679">
<tr>
<td valign="top" width="818" height="677">
<table border="0" width="97%" id="table2" cellpadding="0">
<tr>
<td width="22%" align="center" rowspan="2">
<p align="left"><font size="2" face="Verdana">
<a href="patente.php">
<img border="0" src="http://www.forosdelweb.com/f18/imagen/logo_sedemat20.jpg" width="157" height="145" alt="SEDEMAT" align="middle"></a></font></p>
</td>
<td width="74%" align="center" height="90">
<img border="0" src="http://www.forosdelweb.com/f18/imagen/cabe.gif" width="576" height="90" align="middle"></td>
</tr>
<tr>
<td width="74%" align="center">
<div align="left">
<table border="0" width="98%" cellspacing="0" cellpadding="0" id="table4">
<tr>
<td width="105" valign="bottom">
<p align="right"><b><font face="Verdana" size="2">Fecha:
</font></b></p></td>
<td width="106" valign="bottom">
<p align="justify"><font size="2" face="Verdana"> <?php echo $R["fecha"];?></font></p>
</td>
<td width="105" valign="bottom">
<p align="right"><b><font face="Verdana" size="2"> Planilla:</font></b></p>
</td>
<td width="104" valign="bottom">
<font size="2" face="Verdana"> <?php echo $R["inicial"];?><?php echo $R["id"];?></font></td>
<td width="100" valign="bottom">
<p align="right"><b><font face="Verdana" size="2">PATENTE:</font></b></p>
</td>
<td width="55" valign="bottom">
<font size="2" face="Verdana"> <?php echo $R["patente"];?></font></td>
</tr>
</table></div>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2">
<p align="justify" style="margin-left: 15px; margin-right: 15px">
<font size="2" face="Tahoma"></font></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#DEDDDD" background="../imagen/picgris.gif">
<font color="#DEDDDD" style="font-size: 2pt" face="Verdana">555</font></td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<table border="0" width="99%" id="table3" cellspacing="1" cellpadding="0" height="196">
<tr>
<td height="12" align="justify" colspan="4" valign="top">
</td>
</tr>
<tr>
<td height="54" align="justify" colspan="4" valign="top">
<div align="center">
<table border="0" width="95%" id="table12" cellspacing="0" cellpadding="0" height="50">
<tr>
<td width="425" height="21"><b>
<font face="Verdana" size="2">Contribuyente:</font></b></td>
<td height="21"><b>
<font face="Verdana" size="2">Cedula/RIF:</font></b></td>
</tr>
<tr>
<td width="425">
<font size="2" face="Verdana"><?php echo $R["firstname"];?></font></td>
<td>
<font size="2" face="Verdana"><?php echo $R["nacio"];?><?php echo $R["cedularif"];?></font></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td height="20" align="justify" colspan="4">
<p> </p>
</td>
</tr>
<tr>
<td height="54" align="justify" colspan="4" valign="top">
<div align="center">
<table border="0" width="95%" id="table13" cellspacing="0" cellpadding="0" height="50">
<tr>
<td width="221" height="21"><b>
<font face="Verdana" size="2">Marca de
Vehiculo:</font></b></td>
<td height="21" width="204"><b>
<font face="Verdana" size="2">Modelo de Vehiculo:</font></b></td>
<td height="21" width="162">
<font size="2" face="Verdana"><b>Año Modelo:</b> </font>
</td>
<td height="21"><b><font face="Verdana" size="2">Placa:</font></b></td>
</tr>
<tr>
<td width="221">
<font size="2" face="Verdana"><?php echo $R["marcav"];?></font></td>
<td width="204">
<font size="2" face="Verdana">
<?php echo $R["modelov"];?></font></td>
<td width="162">
<font size="2" face="Verdana">
<?php echo $R["tvano"];?></font></td>
<td><font size="2" face="Verdana"> <?php echo $R["placa"];?></font></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td width="99%" height="20" align="right" colspan="4">
<p align="center"> </td>
</tr>
<tr>
<td height="54" align="right" colspan="4" valign="top">
<div align="center">
<table border="0" width="95%" id="table14" cellspacing="0" cellpadding="0" height="50">
<tr>
<td width="32%" height="21"><b>
<font face="Verdana" size="2">Uso Vehiculo:</font></b></td>
<td height="21" width="33%"><b>
<font face="Verdana" size="2">Observaciones:</font></b></td>
<td height="21" width="17%"> </td>
<td height="21" width="17%"> </td>
</tr>
<tr>
<td width="32%">
<font size="2" face="Verdana"><?php echo $R["tipov"];?></font></td>
<td colspan="3">
<font size="2" face="Verdana"><?php echo $R["observacion"];?></font></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td width="26%" height="12" align="justify">
<p style="margin-left: 30px"></p>
</td>
<td height="12" width="15%">
</td>
<td height="12" width="21%">
</td>
<td height="12" width="37%">
<font size="2" face="Verdana"> </font></td>
</tr>
</table></div>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#DEDDDD" background="../imagen/picgris.gif">
<font color="#DEDDDD" style="font-size: 2pt" face="Verdana">555</font></td>
</tr>
<tr>
<td colspan="2" height="12" align="center"></td>
</tr>
<tr>
<td colspan="2" height="15" align="right"><font size="2" face="Verdana"></font></td>
</tr>
<tr>
<td colspan="2" align="justify"><font size="2" face="Verdana"><?php echo $R["codess"];?></font></td>
</tr>
<tr>
<td colspan="2" height="35">
<p align="justify" style="margin-left: 5px"><font face="Verdana" style="font-size: 8pt">
</font></td>
</tr>
<tr>
<td colspan="2">
<p align="center">
<img border="0" src="http://www.forosdelweb.com/f18/imagen/pie0.gif" width="732" height="76" align="middle"></p>
</td>
</tr>
</table></td>
</tr>
</table>
</body>