Need Help With A Date Script

nmphpwebdev

I have this date script.

I need the script to show all dates from the selected month/year.

//Display current monthly events
            echo "<table width=\"100%\" border=\"1\">\n";
                echo "<tr>\n";
                    echo "<td><b>Event</b></td>\n";
                    echo "<td><b>Start Date</b></td>\n";
                    echo "<td><b>End Date</b></td>\n";
                    echo "<td><b>Location</b></td>\n";
                    echo "<td><b>Contact Person</b></td>\n";
                    echo "<td><b>Comments</b></td>\n";
                echo "</tr>\n";

            if ($_GET['action'] == 'View') {
                $month = str_repeat("0", (2 - strlen($_GET['months']))).$_GET['months'];

                $result2 = mysql_query("select event,
                                                     DATE_FORMAT( startdate, '%M %d, %Y' ) as sd,
                                                     DATE_FORMAT( enddate, '%M %d, %Y' ) as ed,
                                                     location, contact, comments from events where
                                                     startdate = '".$_GET['years']."-$month-01'");
echo $_GET['years'];
echo '&nbsp;';
echo $month;
                    if (mysql_num_rows($result2)) {
                        while ($rows2 = mysql_fetch_array($result2)) {
                            echo "<tr>\n";
                                echo "<td>".$rows2['event']."</td>\n";
                                echo "<td>".$rows2['sd']."</td>\n";
                                echo "<td>".$rows2['ed']."</td>\n";
                                echo "<td>".$rows2['location']."</td>\n";
                                echo "<td>".$rows2['contact']."</td>\n";
                                echo "<td>".$rows2['comments']."</td>\n";
                            echo "</tr>\n";
                        }
                    } else {
                        echo "<tr>\n";
                            echo "<td>&nbsp;</td>\n";
                            echo "<td></td>\n";
                            echo "<td></td>\n";
                            echo "<td></td>\n";
                            echo "<td></td>\n";
                            echo "<td></td>\n";
                        echo "</tr>\n";


                }

            } else {
                //Display current month events only
                if (mysql_num_rows($result1)) {
                    while($rows1 = mysql_fetch_array($result1)) {
                        echo "<tr>\n";
                            echo "<td>".$rows1['event']."</td>\n";
                            echo "<td>".$rows1['sd']."</td>\n";
                            echo "<td>".$rows1['ed']."</td>\n";
                            echo "<td>".$rows1['location']."</td>\n";
                            echo "<td>".$rows1['contact']."</td>\n";
                            echo "<td>".$rows1['comments']."</td>\n";
                        echo "</tr>\n";
                    }
                } else {
                    echo "<tr>\n";
                        echo "<td>&nbsp;</td>\n";
                        echo "<td></td>\n";
                        echo "<td></td>\n";
                        echo "<td></td>\n";
                        echo "<td></td>\n";
                        echo "<td></td>\n";
                    echo "</tr>\n";

                }
            }
                      echo "</table>";
        ?>

When the dates are selected, only the 1st of the month is being returned.

The url is:
http://cahedev.nmsu.edu/eventscopy

Dragnovich

I dont see any problem in the PHP structure, and if you are getting Just one result... the problem will be in the SQL part.

1) generate a $sql var and print his content
2) Copy that query and execute it in the MySQL server and provably you will get just 1 resoult. so Check the SQL something is been grongly requested

TheDefender

On a side note (for future reference), take this line here...

if (mysql_num_rows($result2)) {

One thing to consider is in how you are using the [man]mysql_num_rows[/man] function, because it doesn't return a true or false, it returns the number of rows returned by the result set...

You may want to consider changing it to:

if (mysql_num_rows($result2) > 0) {

Other than that, the page looks fine... I saw something dated October 2, 2004... Did you get your code issue resolved?

Dragnovich

Even that mysql_num_rows() function is "wrongly" used it sould work. When (S)he makes the:

if (mysql_num_rows($result2)) {

the resoult is not affected, when an IF has no comparation it assumes that he will receive a bolean result, but this routine returns him a number, so PHP simply asume that 0 = FALSE and any other numer is TRUE 😃

So thats not the problem! I bet my 2 cents, that is all about the SQL query.

Weedpacket

Originally posted by Dragnovich
So thats not the problem! I bet my 2 cents, that is all about the SQL query.

I agree; look at the dates being asked for...

startdate = '".$_GET['years']."-$month-01'"

I think MySQL has a LAST_DAY function. Use that to define a range, perhaps.

TheDefender

Originally posted by TheDefender
On a side note (for future reference),

I didn't say it was "wrong". I am simply making an observation on how to better utilize the function "for future reference"... especially since I didn't see how the code was failing given the reference URL. Hence, that's why I asked if the code issue was resolved.