Search Form..

I have this code and it is only returning one user, when it should return about 20..


<cfquery name="search" datasource="userlogin">
Select
<cfif isDefined("form.user_level")>battle.*</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>, </cfif>
<cfif isDefined("form.money")>finance.* </cfif>
FROM
<cfif isDefined("form.user_level")>battle</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>,</cfif>
<cfif isDefined("form.money")>finance</cfif>
WHERE
<cfif isDefined("form.user_level")>
battle.user_level >= #form.llevel# AND battle.user_Level <= #Form.mlevel#</cfif>

<cfif isDefined("form.money") AND isDefined("form.user_level")>AND</cfif>

<cfif isDefined("form.money")>#form.lpocket# <= finance.pocket AND #Form.mpocket# >= finance.pocket</cfif>
</cfquery>
<cfoutput query="search">
<cfset id = "#user_ID#">
</cfoutput>

<cfquery name="getname" datasource="userlogin">
SELECT * from registration_info
WHERE user_id = '<cfoutput>#ID#</cfoutput>'
</cfquery>
<cfoutput query="getname">
#user_name#
</cfoutput>

this code works but returns them about 20 times each

<cfquery name="search" datasource="userlogin">
Select
<cfif isDefined("form.user_level")>battle.*</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>, </cfif>
<cfif isDefined("form.money")>finance.* </cfif>
FROM
<cfif isDefined("form.user_level")>battle</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>,</cfif>
<cfif isDefined("form.money")>finance</cfif>
WHERE
<cfif isDefined("form.user_level")>
battle.user_level >= #form.llevel# AND battle.user_Level <= #Form.mlevel#</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>AND</cfif>
<cfif isDefined("form.money")>#form.lpocket# <= finance.pocket AND #Form.mpocket# >= finance.pocket</cfif>
</cfquery>
<cfoutput query="search">
#user_id#
</cfoutput>



another question:
when i search by both level and pocket, it returns all users with those level, and all users with that pocket.. instead of returning the user with that level AND pocket

Any help please?

Anyone.. ? :S