Webmaster Forum / ColdFusion / Getting Started / September 2004

i have..

Search for Account:<br><br>
<form name="changeUser" action="viewaccountformresults.cfm" method="post">
Search By Username:
<input type="text" name="user_name">
<input type="Submit" value="Search!">
</form>

Search Results<br><br>
Here are your results from your search:<br></center>
<br>
<cfquery name="registration" datasource="userlogin">
SELECT *
FROM registration_info
where user_name Like '%#form.user_name#%'
</cfquery>
<cfoutput query="registration">
<li><a href="viewaccount.cfm?ID="#user_id#">#user_name#</a></li>
</cfoutput>

I dont think i did the link part right, as that is where i am stuck... and
also on the next page that actually shows the information and stuff for who
they were searching for.. how would i do that because they searched by
user_name, but user_Name is only in one table and i need information from all
tables.. they are all joined together by user_id but im dumb with tables
joins.. can someone help

<cfquery name="alignment" datasource="userlogin">
SELECT *
FROM alignment
where user_ID = '#URL.user_ID#'
</cfquery>
<cfoutput query="alignment">