Re: Variables not passing...

One other irritation for the evening... The MySQL query that I am trying to create needs to use the date the user enters and then add " @ 12:01am EST" to it so it will acutally match the data in the table. Below is my quesry line, but I don't know how to add that chunk to each of the variables... $result = mysql_query("SELECT * FROM $table WHERE 'submit_date' >= '$startdate' AND 'submit_date' <= '$stopdate' ORDER BY 'submit_date' DESC", $link); <daniel@electroteque.org> wrote in message news:40256.203.15.102.65.1078462900.squirrel@www.electroteque.org... > Is there a session_start() on the second page ? > > Also i didnt know u could set an action to a jscript popup, it may not be > posting to the second page. What you could try is posting to the second > page like a normal post, u need to do something like > > > session_start(); > $_SESSION['startdate'] = $_POST['startdate']; > $_SESSION['stopdate'] = $_POST['stopdate']; > > in the second page > > u only need this if u are then redirecting to yet another page > > else just do a > > > <h1 align="center"><strong>Reports received between <?php echo > > "".$_POST['startdate'].""; ?> and <?php echo > > "$_POST['stopdate']"; ? > >:</strong></h1> > > > something like that > > > > Okay, I am sure this will be painfully simple, but I have looked it > > over for a couple of hours now, and I am obviously missing something. > > I am trying to get a start date and a stop date via input from a user > > to use as variables in a MySQL query, but for some reason, I can't get > > the variable to pass from one page to the next... Will one of you > > masters help me find my goof? > > > > First page has the following at the top of the code: > > <?php > > session_start(); > > $_SESSION['startdate'] = $startdate; > > $_SESSION['stopdate'] = $stopdate; > > ?> > > > > > > Then I am getting the data entry in the following form code: > > <form name="viewbydate" method="post" > > action="javascript:popUp('viewbydate.php')"> > > <li> All reports from one date to another: Start > > <input name="startdate" type="text" size="15" > > maxlength="30"> > > Stop > > <input name="stopdate" type="text" size="15" > > maxlength="30"> > > <input name="button2" type="submit" value="GO"> > > </form> > > > > > > The second page starts by displaying this info: > > <h1 align="center"><strong>Reports received between <?php echo > > "$startdate"; ?> and <?php echo "$stopdate"; > > ?>:</strong></h1> > > > > > > The regular text displays, but there is just white space where the > > $startdate and $stopdate should be. > > > > Thanks in Advance!! > > Chase > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php