Hi everyone,

I created a form using six drop down boxes to let people specify a time frame when pulling their data from my database (start year, start month, start day, end year, end month, end day). When people adjust their drop down menus and click submit, my page reloads, checks the variables for security, enters them into the MySQL query, and executes the query, and drops the data into the page.

It works well, but here's the problem:

When people load the page initially, no data appears. They have to click the submit button on my time frame form in order for the page to reload and data to appear.

It makes sense why this happens, but does anyone know how to get data to initially appear, such as year-to-date or all time data to show when they first visit the page?

Any suggestions would be great. Thanks!

You are just going to have to create defulat values at the point where the form vars are processed.

Thanks, mgraphic.

I added this to my script:

if(!isset($_GET['syear'])) $syear = "2008"; 
else $syear = $_GET["syear"];
if(!isset($_GET['smonth'])) $smonth = "1"; 
else $smonth = $_GET["smonth"];
if(!isset($_GET['sday'])) $sday = "1"; 
else $sday = $_GET["sday"];
if(!isset($_GET['eyear'])) $eyear = "2009"; 
else $eyear = $_GET["eyear"];
if(!isset($_GET['emonth'])) $emonth = "1"; 
else $emonth = $_GET["emonth"];
if(!isset($_GET['eday'])) $eday = "1"; 
else $eday = $_GET["eday"];

It's designed to give a time frame between Jan 1, 2008 through Jan 1, 2009. But that's not working. I even echoed out my variables and saw it wasn't saving anything.

Am I doing something wrong?

Thanks again, everyone.

Nevermind, figured it out... a piece of code earlier in my script was clearing the variable values.

For people who visit this post in the future, the above code DOES work.