I have created a database table which stores info from a user submitted form. One of the fields is Date which is derived from the server date when the user submits the form. I want to create a search filter where I can view all of the records entered since a date I enter.
I am familiar with SELECT WHERE to select records from the table. I created a form where I can enter a date and assign the value to a variable such as $selected_date.
If I try something such as:
$sql = mysql_query("SELECT * FROM Surveyinfo WHERE Date > '$select_date' LIMIT $from, $max_results");
I get errors.
I think it must be because my entered date is not in the proper format but after much searching and tutorial reading, I have been unable to figure out how to do this. Can any one help.
