just listen to this query:
$query="select user_profile.userid,user_profile.date,user_profile.time_in,user_log.time_out from user_profile,user_log WHERE user_profile.date >'$date1' AND user_profile.date<'$date2'";
Now for this i want to list them
With the following code i am unable to:
echo"<BODY LINK='#ffffff' VLINK='#ff0000' BGCOLOR='#000040' BACKGROUND='images/images/bbar.gif'>
<div align='center'>
<table border='3' cellspacing='1' cellpadding='3' align='center' bgcolor='#808080' height='20' width='610' bordercolorlight='#B4B467' bordercolordark='#76763A'>
<tr>
<th width='6%' bgcolor='#FF9966' bordercolorlight='#A9A954' bordercolordark='#959595' NOWRAP><font face='copperplate gothic bold,sans-serif' color='#800000' size='3'>
userid</font>
</th>
<th width='6%' bgcolor='#FF9966' bordercolorlight='#A9A954' bordercolordark='#959595' NOWRAP><font face='copperplate gothic bold,sans-serif' color='#800000' size='3'>
date</font>
</th>
<th width='6%' bgcolor='#FF9966' bordercolorlight='#A9A954' bordercolordark='#959595' NOWRAP><font face='copperplate gothic bold,sans-serif' color='#800000' size='3'>
Time_in</font>
</th>
<th width='6%' bgcolor='#FF9966' bordercolorlight='#A9A954' bordercolordark='#959595' NOWRAP><font face='copperplate gothic bold,sans-serif' color='#800000' size='3'>
Time_out</font>
</th>
</tr>";
while($query_data=mysql_fetch_array($result35))
{
$userid=$query_data["userid"];
$date=$query_data["date"];
$time_in=$query_data["time_in"];
$time_out=$query_data["time_out"];
echo "<TR>\n
<td width='85%' height='19' bgcolor='#EBD381' ALIGN='LEFT'><font face='Arial, Helvetica'>$userid</font></td>\n
<td width='25%' height='19' bgcolor='#EBD381' ALIGN='CENTER'><font face='Arial, Helvetica'>$date</font></td>\n
<td width='25%' height='19' bgcolor='#EBD381' ALIGN='CENTER'><font face='Arial, Helvetica'>$time_in</font></td>\n
<td width='25%' height='19' bgcolor='#EBD381' ALIGN='CENTER'><font face='Arial, Helvetica'>$time_out</font></td>\n
</TR>\n";
}
echo"</table>
</div>";
Please help
