Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\intranet\scripcumple.php on line 7
Cita:
<?php
include 'conexion.php';
conectar();
$my_result = mysql_query ("SELECT * FROM usuarios WHERE MONTH(fechnac) = MONTH(NOW()");
while ($myrow = mysql_fetch_assoc($my_result))
{
?>
<table border="1" width="30%" cellpadding="4" cellspacing="0">
<tr>
<td width="100%" bgcolor="#FFCC00"><strong><em><img src="icons/cake.gif" width="17" height="19">Listados de Cumpleaños del Mes</em></strong><b></td>
</tr>
<tr>
<td width="100%">Nombre :<?php echo $myrow["nom"];?> <?php echo $myrow["apellido1"];?><?php echo $myrow["apellido2"];?></td>
</tr>
<tr>
<td width="100%">Fecha de Nacimiento : <?php echo $myrow["fechnac"];?></td>
</tr>
<td width="100%">Establecimiento : <?php echo $myrow["establecimiento"];?></td>
</tr>
<table border="1" width="100%" cellpadding="4" cellspacing="0" bgcolor="#00FF00">
</tr>
</table>
</table>
<br/>
<?php }
desconectar();
?>
include 'conexion.php';
conectar();
$my_result = mysql_query ("SELECT * FROM usuarios WHERE MONTH(fechnac) = MONTH(NOW()");
while ($myrow = mysql_fetch_assoc($my_result))
{
?>
<table border="1" width="30%" cellpadding="4" cellspacing="0">
<tr>
<td width="100%" bgcolor="#FFCC00"><strong><em><img src="icons/cake.gif" width="17" height="19">Listados de Cumpleaños del Mes</em></strong><b></td>
</tr>
<tr>
<td width="100%">Nombre :<?php echo $myrow["nom"];?> <?php echo $myrow["apellido1"];?><?php echo $myrow["apellido2"];?></td>
</tr>
<tr>
<td width="100%">Fecha de Nacimiento : <?php echo $myrow["fechnac"];?></td>
</tr>
<td width="100%">Establecimiento : <?php echo $myrow["establecimiento"];?></td>
</tr>
<table border="1" width="100%" cellpadding="4" cellspacing="0" bgcolor="#00FF00">
</tr>
</table>
</table>
<br/>
<?php }
desconectar();
?>