the search Problem

I am searching in my forums while i am facing such a stupid error where i cannot the one. here is the query which is running though.

<form action="<cfoutput>#siteurl#</cfoutput>/common/search_action.cfm" method="post">
<tr>
<td><strong>Search Phrase:</strong></td>
<td><span id="sprySearch">
<input name="searchphrase" type="text" id="searchphrase" size="60" />
<span class="textfieldRequiredMsg"><img src="../images/cross.gif" /></span></span></td>
<td rowspan="10" valign="top">
<strong>Categories</strong>:<br>
<select name="SearchIn" size="10" multiple>
<OPTION value="" selected>ALL</OPTION>
<CFLOOP query="GetCats">
<cfoutput>
<OPTION value="c_#cat_id#">#cat_name#</OPTION>
</cfoutput>
<CFLOOP query="GetForums">
<cfoutput>
<OPTION value="f_#forum_id#">#forum_name#</OPTION>
</cfoutput>
</CFLOOP>
</CFLOOP>
</SELECT> </td>
</tr>
<tr>
<td><strong>Search what?:</strong></td>
<td><select name="searchwhat">
<OPTION value="both">Title or Body</OPTION>
<OPTION value="name">Title Only</OPTION>
<OPTION value="body">Body Only</OPTION>
</SELECT> </td>
</tr>
<tr>
<td><strong>Author:</strong></td>
<td><select name="author">
<OPTION value="">(Select One)...</OPTION>
<cfloop query="GetTotalUsers">
<cfoutput>
<OPTION value="#GetTotalUsers.UserLogin#">#GetTotalUsers.UserLogin#</OPTION>
</cfoutput>
</cfloop>
</SELECT> </td>
</tr>
<tr>
<td><strong>Only search topics that have been answered:</strong></td>
<td><input type="checkbox" name="answered" value=""></td>
</tr>
<tr align="left">
<td><strong>Start Date:</strong></td>
<td><span id="spryStartDate">
<input type="text" name="date3" id="date3" tabindex="2" size="40" />
<span class="textfieldInvalidFormatMsg"><img src="../images/cross.gif" /></span></span></td>
</tr>
<tr align="left">
<td><strong>End Date:</strong></td>
<td><span id="spryEndDate">
<input type="text" name="date4" id="date4" tabindex="3" size="40" />
<span class="textfieldInvalidFormatMsg"><img src="../images/cross.gif" /></span></span></td>
</tr>
<tr>
<td height="24" align="center"> </td>
<td><input type="submit" value="Search Now">
    
<input type="reset" value="Reset" /></td>
</tr>
<tr>
<td height="24" colspan="2" align="center"><div align="left">
<ul>
<li><strong>Enter StartDate and EndDate as YYYY-MM-DD</strong></li>
</ul>
</div></td>
</tr>
</form>

and there in next page i do a search:

<CFQUERY name="GetPostPhrase" datasource="#request.dsn#" username="#request.dsnuser#" password="#request.dsnpasswd#">
SELECT *
FROM posts
where
<Cfif form.searchwhat is "both">
post_name like '%#form.searchphrase#%' or post_body like '%#form.searchphrase#%'
<cfelseif form.SEARCHWHAT is "name">
post_name like '%#form.searchphrase#%'
<cfelse>
post_body like '%#form.searchphrase#%'

<cfif Len(form.date3) IS NOT 0 AND Len(form.date4) IS NOT 0>
AND
(post_Date BETWEEN #CreateODBCdate(form.date3)# AND #CreateODBCdate(form.date4)#)
</cfif>
</CFIF>
</CFQUERY>

but search within the dates are not working as i am looking into, can anyone please tell me what's wrong i am doing?

Regards

I am using mysql database