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);
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
