I'm using a form to submit search criteria to a mysql select statement. The form and the select statment are on the same page. PHP starts out by testing:
if(!$submit){display the html form}
The form has an
<input type=submit name=submit...>
when the user clicks on the submit button the test evaluates to false, the criteria are submited to the same page, then:
else{perform select statment according to the submitted criterea}
The select statement creates a table based on the returned query data and names the table $user_name. $user_name was gathered and passed to my search page via a url from the previous page.
I can see $user_name on my search page just fine, right up to the time I hit the submit button and the search criteria are passed to the select statement. The $user_name variable is gone of course because the page gets re-evaluated and there's nothing to feed it the variable value the second time around.
I was hoping someone out here might have a solution to my problem 🙂
Thanks
DN
