----- Original Message -----
From: "Jim Lucas" <[EMAIL PROTECTED]>
To: "Bart Verbeek" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
> Try this:
>
> <<< BEGIN:PHP-CODE >>>
>
> $result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE name
> LIKE '$PHP_AUTH_USER' GROUP BY date ORDER BY date");
> if (mysql_num_rows($result))
> {
> for($i=0;$i<count($row);$i++)
> {
> $date = array(
> "begin" => array($i => $row["date"]),
> "end" => array($i => $row["date"])
> );
> }
> } else {
> print ("Sorry, no record were found.");
> }
>
> function drawSelect($which)
> {
> global $date;
> foreach($date[$which] AS $date_begin)
> {
> ?>
> <option value="<?=$date_begin?>"><?=$date_begin?></option>
> <?
> }
>
> }
>
> ?>
> <table>
> <tr>
> <td>Begindate</td>
> <td>Enddate</td>
> </tr>
> <tr>
> <td><form method="post" action="index.php" name="date_select">
> <input type="hidden" name="action" value="date_select">
> <select name="date_begin">
> <?
> drawSelect("begin");
> ?>
> </select>
> </td>
> <td><select name="date_end">
> <?
> rsort($date[end]);
>
> drawSelect("end");
> ?>
> </select>
> </td>
> </tr>
> <tr>
> <td colspan="2"><input type="submit" name="Submit"
> value="Submit"></form></td>
> </tr></table>
>
> <<< END:PHP-CODE >>>
>
> btw - you need to watch your closing '>' you are missing a few. Plus to
> get distince to work right you need to use the "GROUP BY" clause.
>
> Jim
>
> ----- Original Message -----
> From: "Bart Verbeek" <[EMAIL PROTECTED]>
> To: "Php-General-list" <[EMAIL PROTECTED]>; "PHP-DB mailinglist"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, October 24, 2001 12:23 PM
> Subject: [PHP-DB] array-problems
>
>
> > Hello,
> > Can anyone help me with this script I'm using?
> >
> > I've saved dates in a database and want to make two select-lists of
these
> > dates in a html-form.
> > I want to select each unique date one time (no doubles).
> > List 1 is used to set the begin-date of the query for the report, List 2
> > will
> > set the end-date and must be reversed.
> > When the form is processed the data selected between the begin-date and
> the
> > end-date has to be show.
> >
> > I can't seem to get my code to work: the select-lists stay empty after
> > processing the code below.
> >
> > Can anyone help? Tips...
> >
> > regards,
> >
> > Bart
> >
> >
> > <<< BEGIN:PHP-CODE >>>
> > $i=0;
> > $result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE
name
> > LIKE '$PHP_AUTH_USER' ORDER BY date");
> > if ($row = mysql_fetch_array($result)) {
> > do {
> > $date = array(
> > "begin" => array($i => $row["date"]),
> > "end" => array($i => $row["date"])
> > );
> > $i++;
> > } while ($row = mysql_fetch_array($result));
> > } else {print ("Sorry, no record were found.");
> > } //end else $result
> >
> > print("<table><tr><td>Begindate</td<td>Enddate</td></tr>\n".
> > "<tr><td><form method=\"post\" action=\"index.php\"
> > name=\"date_select\">".
> > "<input type=\"hidden\" name=\"action\"
> > value=\"date_select\">".
> > "<select name=\"date_begin\">");
> >
> > while (list($key, $date_begin) = each($date[begin])) {
> > echo "<option value=\"".$date_begin ."\">" . $date_begin .
> > "</option>\n";
> > }
> >
> > print("</select></td><td><select name=\"date_end\">");
> >
> > rsort($date[end]);
> >
> > while (list($key, $date_end) = each($date[end])) {
> > echo "<option value=\"".$date_end ."\">" . $date_end .
> > "</option>\n";
> > }
> >
> > print("</select></td></tr>\n<tr><td colspan=\"2\">".
> > "<input type=\"submit\" name=\"Submit\"
value=\"Submit\">".
> > "</form></td></tr</table>");
> >
> > mysql_free_result ($result);
> > mysql_close();
> > <<< END:PHP-CODE >>>
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
