[roxics]

Can someone help me with this. I'm trying to get the next 10 events for the next ten days on the calendar to show on this page. But I'm pretty clueless as to what I'm doing.

Here is the page:
http://www.visionengine.com/board/view.php?s=&pg=events

Here is my query

PHP Code:

SELECT *
FROM calendar_events
WHERE public = 1 AND eventdate >= +10()
ORDER BY eventdate LIMIT 10 


Here is my query result row

PHP Code:

<table border='0' cellspacing='0' cellpadding='0' width='100%'>
<tr><td bgcolor='#000000' width='100%' height="0" > 
<table width='100%' border='0' cellspacing='1' cellpadding='3'>
<tr>
<td bgcolor='#cecfce' width='100%'>
      <div align="left">
<font style="FONT-FAMILY: Verdana, MS Sans Serif;FONT-SIZE: 10pt;"><b>Event</b> $WQfield[subject]<br>
<font style="FONT-FAMILY: Verdana, MS Sans Serif;FONT-SIZE: 10pt;"><b>From 
       :</b> <a href="$bburl/member.php?s=&action=getinfo&userid=$WQfield[postuserid]">$WQfield[username]</a></div>
      <div align="right"><font style="FONT-FAMILY: Verdana, MS Sans Serif;FONT-SIZE: 8pt;"><b>Date:</b> $WQfield[eventdate]</div></td>
</tr>
<tr> 
     <td bgcolor='#F1F1F1' width='100%' height="5" align='left'> 
      <font style="FONT-FAMILY: Verdana, MS Sans Serif;FONT-SIZE: 10pt;"> 
      $WQfield[event]</font> </td>
</tr>
</table>
</td>
</tr>
</table>
<br> 


On top of that I can't seem to get the username to show up. Or manage to get it so the event information is formatted properly.