Busy — Fri, 02 Jun 2006 23:16:43 +0000

I only know PHP, not ASP so am not sure of the code needed, bascially opposite to receiving the database info, with PHP it would be select * from ... (get stuff from database) and insert into ... (put stuff in database).

The form data would be the same stuff used to get the results as it would be recorded in the database. Hopefully someone that knows ASP can show you the code needed.

Basically it goes like this:
results page

get data from form
get username from session
validate all input, if anything blank or wrong go back to search page with error
insert searched data into database
get form query data from database that matches user input
display results
wish them a happy day and remind them to watch out for the plant on their way out

malhyp — Fri, 02 Jun 2006 16:02:09 +0000

Hey there, so in the results.asp page I create a recordset that pulls the results. How do I get the results submitted to the database from there? The username is being passed with a session variable.

Busy — Thu, 01 Jun 2006 09:53:16 +0000

You have 3 of the things going to the results page anyway, so on the results page just add the database query at top before the results.
As for the UserName, are you using cookies or anything? if so get it from there, otherwise just add to the search form on search page

Welcome to TWF