PHP - If Statement Inside If Statement Not Working

I am trying to create a daily event listing.

The list will have Day & Date as the heading. Then it will list the events ORDERED BY the time.

First thing I'd like to do is skip or not show the days that do not have an event.
Ex.
Monday, January 23, 2012
7am event
8am event
6pm event

since Tuesday has no events, I'd like tuesday to not be in the list, but if the next tuesday has an event It'll need be visible.
Tuesday, January 24, 2012
(No events)

Wednesday, January 25, 2012
9am event
12 pm event
8pm event

The 2nd thing I'd like to do is If a particular day and time has more than one event, I'd like the time to show once and then list the events.
ex.
Monday, January 23, 2012
7am event
        event
        event
8am event
6pm event


Here's the code: since the listing is for a range of 7 days I've only included 3 days worth of code. I've include the mysql_statements for pulling the information as well as the php code to show how it's being rendered and placed.  HTML excluded.

Code: [Select]
<?php
//TODAY
$today2 = date('l, F j, Y');//php to format date

$today_rehearsals = mysql_query(" SELECT Id, date, time, title, campus, room, ministry, category FROM events
     LEFT JOIN dates on events.dateId=dates.dateId
     LEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomIdLEFT JOIN ministries on events.ministryId=ministries.ministryId
     LEFT JOIN category on events.categoryId=category.categoryIdWHERE ministry='music' AND date='$today' OR category='music' AND date='$today'            
     ORDER By date, time")

//////DAY  ONE
$day1= mktime(0,0,0, date("m"), date("d")+1, date("Y")); //php to get current date and add 1 day
$day_1 = date("l, F j, Y", $day1); //php to format date

$day1_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+1 OR category='music' AND date=CURDATE()+1 ORDER BY time" ) or die(mysql_error());

/////DAY 2
$day2= mktime(0,0,0, date("m"), date("d")+2, date("Y")); //php to get current date and add 2 days
$day_2 = date("l, F j, Y", $day2); //php to format date

$day2_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+2 OR category='music' AND date=CURDATE()+2 ORDER By time")or die(mysql_error()); 



////TODAY
echo "$today2"; //renders Today's date 
    
     while($row = mysql_fetch_array( $today_rehearsals )){ 
          $time=date_create($row['time']);//grab time for db          
          $for_time=date_format($time, 'g:i a');//format time for viewing on page   

           echo "$for_time";           
           echo $row['title'];           
           echo $row['campus'] . " " . $row['room'];    
     }


////day1
echo "$day_1"; //renders day_1's (tomorrow's) date

     while($row = mysql_fetch_array( $day1_rehearsal )){ 
          $time=date_create($row['time']);//grab time for db         
          $for_time=date_format($time, 'g:i a');//format time for viewing on page
                          
          echo "$for_time";          
          echo $row['title'];          
          echo $row['campus'] . " " . $row['room'];
          }

////day2
echo "$day_2"; //renders day_2's (day after tommorrow) date

     while($row = mysql_fetch_array( $day2_rehearsal )){                      
         $time=date_create($row['time']);//grab time for db
         $for_time=date_format($time, 'g:i a');//format time for viewing on page                                     

          echo "$for_time"; 
          echo $row['title'];
          echo $row['campus'] . " " . $row['room'];
          }

MOD EDIT: code tags fixed . . .

I have the following code which gets staff working on a selected day and their start and finish times.
The code then lists out the day for every 15min of time for each staff member.
During the loop of each staff member I then check an appointment table to see if a user has any appointments, and lists the booked time slots, if no appointments lists user as available for all the time slots.
My problem is when a user has appointments it only shows the booked times and not the available times.
I know the problem lies here


else if ($inc<$resSTART && $inc>$resEND) {


and the complete code that is from is here


// convet to US format
$input="$month/$day/$year";
// readable date
$readDATE="$day/$month/$year";
// convert for mysql date
$sqlDATE="$year-$month-$day";
// get day of the week
$weekday=date(l, strtotime($input));
echo $weekday."<br/>";
// get working staff from staff table
$staffSQL=mysql_query("SELECT * FROM staff WHERE ".$weekday." != 'off' AND onLEAVE='no' AND ACTIVE='yes' ORDER BY staffID ASC");
// return results
putenv("TZ=Australia/Adelaide");
while ($staff=mysql_fetch_array($staffSQL)) {
$name=$staff['staffNAME'];
$avail=$staff[$weekday];
$staffID=$staff['staffID'];
list($first, $last)=explode(" ", $name);
list($in, $out)=explode("-", $avail);
$firstTIME="$sqlDATE $in:00";
$lastTIME="$sqlDATE $out:00";
echo "$first is available between $avail on $weekday<br/>";
$in2=strtotime($firstTIME);
$out2=strtotime($lastTIME);
$stop=$out2-900;
echo $in2." - time start - $firstTIME<br/>"; 
echo $out2." - time finish - $lastTIME<br/>";
for ($inc=$in2;$inc<=$stop;$inc+=900) {
$existSQL=mysql_query("SELECT * FROM appointment WHERE date='$sqlDATE' AND staffID='$staffID'");
if (mysql_num_rows($existSQL)>=1) {
while ($appointV=mysql_fetch_array($existSQL)) {
$resSTART=$appointV['dateTIME'];
$length=$appointV['totalTIME'];
$resEND=$resSTART+($length*60);
if ($inc>=$resSTART && $inc<=$resEND) {
echo "Appointment time is ".date("g.i a", $inc)." <font color='red'><< $first BOOKED</font><br/>";
} else if ($inc<$resSTART && $inc>$resEND) {
echo "Appointment time is ".date("g.i a", $inc)." <font color='green'><< $first AVAILABLE</font><br/>";
}
}
}
if (mysql_num_rows($existSQL)==0) {
echo "Appointment time is ".date("g.i a", $inc)." <font color='green'><< $first AVAILABLE</font><br/>";
}
}
}



any ideas how to restructure that if statement to work properly would be very much appreciated

I am wondering if it is possible to create 2 queries, and use 1 while statement?
Something like:

Code: [Select]
while (($row = mysql_fetch_array($rs_getevent)) && ($row = mysql_fetch_array($rs_getevent2))) {
Is something like this possible?

After it goes through the while loop its supposed to take the ID of the first one in the loop and find out its awardType and then with the awardType variable go through the the if statement. After it displays it the code that fits the awardType variable then it gets the second item in the while loop and then with the ID of the second item takes it back to get the  awardType and then goes back through the if statement again. I'm not sure what I'm doing wrong. As of right now all its doing is displaying its awardName and a blank dropdown.

Code: [Select]
<?php

session_start(); // Access the existing session

// Include the database page
require ('../../inc/dbconfig.php');l

$userID = $_SESSION['userID'];

$statusQuery = "
    SELECT 
        * 
    FROM 
        statuses";
$statusResult = mysqli_query ( $dbc, $statusQuery ); // Run The Query 

$awardQuery = "
    SELECT
        awards.ID,
        awards.awardName,
        awards.awardType
    FROM
        awards";
$awardResult = mysqli_query ( $dbc, $awardQuery ); // Run The Query
$row = mysqli_fetch_array ( $awardResult, MYSQL_ASSOC );

$awardType = $row[ 'awardType' ];

$charactersQuery = "
    SELECT 
        characters.ID, 
        characters.characterName 
    FROM 
        characters
    ORDER BY 
        characters.characterName";
$charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query

$matchQuery = "
    SELECT
        eventSegments.ID,
        eventSegments.segmentTitle
    FROM
        eventSegments
        INNER JOIN events
            ON eventSegments.eventID = events.ID
    WHERE
        DATE_FORMAT(events.bookingDate,'%Y') = DATE_FORMAT(curdate(),'%Y')";
$matchResult = mysqli_query ( $dbc, $matchQuery ); // Run The Query


?>

Code: [Select]
<fieldset>
<legend>Nominees</legend>
        <?php 
        mysqli_data_seek( $awardResult, 0 );
        while ( $row = mysqli_fetch_array ( $awardResult, MYSQL_ASSOC ) ) { ?>
        <?php if ($awardType == 'Singular') { ?>
        <div class="field required">
<label for="charactersDrop"><?php echo $row['awardName']; ?></label>
<select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Drop">
                <option value="">- Select -</option>
               <?php
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) { 
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
            </select>
            <input type="button" value="Add Character" class="" onclick="HandlerCharacters()"/>
            <ul id="characterList">
            </ul>
            <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
        </div>
        <? } else { ?>
        <div class="field required">
<label for="events"><?php echo $row['awardName']; ?></label>
<select class="dropdown" name="events" id="events" title="Events for <?php echo date("Y") ?>">
                <option value="">- Select -</option>
               <?php
                    while ( $row = mysqli_fetch_array ( $matchResult, MYSQL_ASSOC ) ) { 
                        print "<option value=\"".$row['ID']."\">".$row['segmentTitle']."</option>\r";
                    }
                ?>
            </select>
            <input type="button" value="Add Match" class="" onclick="AddMatch()"/>
            <ul id="matchList">
            </ul>
            <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
        </div>
        <?php } ?>
        <?php } ?>

Hi everyone.

i'm trying to write an if statement for several scenerios
1. if the date entered in '$DateDue' is overdue, meaning greater than todays date, then display the word 'Late'.
2. if the date entered in '$DateDue' is not yet past, meaning its greater than todays date, then display the word 'ok'.
3. if the date entered in '$DateDue' is within a week of todays date, then display the word 'warning'

the code snippet below is my partial script. it runs perfectly without embedding the 'php if statement' on the first td row. So my problems a
1. how to embed a php if statement in table results and
2. have OK, LATE or WARNING to be displayed based on if $DateDue expires or not.
there are no errors in the code below, it just echos the line '<?php if ($DataDue > CURDATE()) {echo "OK";} elseif ($DateDue < CURDATE()) {echo "LATE";} else {echo "Warning";}?>' instead of displaying OK, LATE or Warning.

I'd appreciate any assistance you could provide. thanks.

Code: [Select]
           
// echo out the contents of each row into a table
echo "<tr>";
echo '<td nowrap><?php if ($DataDue > CURDATE()) {echo "OK";} elseif ($DateDue < CURDATE()) {echo "LATE";} else {echo "Warning";}?>' . mysql_result($result, $i, 'DateDue') . '</td>';
echo '<td nowrap>' . mysql_result($result, $i, 'Description') . '</td>';
echo '<td nowrap>' . mysql_result($result, $i, 'CompanyName') . '</td>';   
echo "</tr>";