PHP - Or Statement With Multiple And Statements

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 . . .

Hi There,

Im trying to figure out how to do this if/else statement. I need it to say, "if this is true, do this. if this is true, do this. If neither is true, do this.

So there are three different possible outcomes. I tried to put each new if inside of the previous else. but that doesn't seem to work.



$firstname = $_REQUEST['firstname'];
$lastname = $_REQUEST['lastname'];

if ($firstname == 'Joey' and $lastname == 'Hodara')
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', Oh Glorious Leader!';

}

else 
{  

if ($firstname == 'Matt' and $lastname == 'Fig') 
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', Portagee!';
}

else{
if ($firstname == 'Jon' and $lastname == 'Spense') 
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', bro!';
}

}

$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ' ' . htmlspecialchars($lastname, ENT_QUOTES, 'UTF-8') . '!';




?>

Hey everyone, i am currently working on a "contact us" script. I want the form to first allow the user which department they want to email. E.g. "Sales" and "Support" By changing this drop down box it will change which email the form is sent to. Im having trouble setting the PHP side of this script up to change the emails. Any help regarding this matter is much appreciated.

HTML FORM:
Code: [Select]
<form name="contactForm" method="post"  action="forms/contactUs.php">
                        <table width="350" border="0">
                            <tr>
                                <td width="150" class="bold">Department:</td>
                                <td width="200" align="left">
                                <select name="department" class="dropDown">
                                  <option value="sales">Sales</option>
                                  <option value="support">Support</option>
                                    </select>
                            </td>
                            </tr>
                            <tr>
                                <td class="bold">Full Name:</td>
                                <td>
                                <input name="name" type="text" class="contactTextBox"  />
                                </td>
                            </tr>
                            <tr>
                                <td class="bold">Company:</td>
                                <td>
                                <input name="company" type="text" class="contactTextBox" />
                                </td>
                            </tr>
                            <tr>
                                <td class="bold">Email:</td>
                                <td>
                                <input name="email" type="text" class="contactTextBox" />
                                </td>
                            </tr>
                            <tr>
                                <td class="bold">Comments:</td>
                                <td>
                                <textarea name="com" id="com" cols="5" rows="5" class="contactTextArea" /></textarea>
                                </td>
                            </tr>
                            <tr>
                                <td>&nbsp;
                                                               
                                </td>
                                <td align="right">
                                <input type="submit" class="button" value="Submit"  /> <input type="reset" class="button" value="Reset"  />
                                </td>
                            </tr>
                        </table>
</form>PHP
<?php

$department = $_POST['department'];
$confirm = "sales";

if(isset($_POST['email'])) {
if($department == $confirm) {
$email_to = "sales@pixemadesigns.com";
$email_subject = "Sales Question";
}
else 
{
$email_to = "support@pixemadesigns.com";
$email_subject = "Support Question";
}

$fullName = $_POST['name'];
$company = $_POST['company'];
$email_from = $_POST['email'];
$comments = $_POST['com'];

$email_message = "Form details below.\n\n";

function clean_string($string) {
  $bad = array("content-type","bcc:","to:","cc:","href");
  return str_replace($bad,"",$string);
}

$email_message .= "Full Name: ".clean_string($fullName)."\n";
$email_message .= "Company: ".clean_string($company)."\n";
$email_message .= "Email: ".clean_string($email_from)."\n";
$email_message .= "Comments: ".clean_string($comments)."\n";


// create email headers
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);  

header("location: ../contactSubmit.html");

?>



<?
}
?>

Hi.

Currently I have code the uses both TRUE. IF statements and FALSE statements to move on. 

For example.

Is it better to use:

Code: [Select]
Where B=A
C=A

IF A=B {
IF C=B{
ECHO 'HELLO WORLD';

}ELSE
ECHO 'C DOES NOT EQUAL B';

}ELSE
ECHO 'A DOES NOT EQUAL B'; '

OR is it better to do it like this:


Code: [Select]
Where B=A
C=A

IF A<>B {
ECHO 'C DOES NOT EQUAL B';

ELSE

IF C<>B{
ECHO 'C DOES NOT EQUAL B';

ELSE

ECHO 'HELLO WORLD';
'[/code

[About the code]
Basically what I have is a web page that de-codes a complex XML document, and displays it as a table.
This is working successfully.
One of the columns in the tables displays a "rank" of an object as a number (0-9).
This is working successfully.
What I did was write a code that would translate that rank number into a specified text, depending what number it was.

[The Code]
(This is only the partial code with the problem in it, the entire code of the page is very extensive.)
Code: [Select]
$RankNum = "{$Member->Rank}";
// {$Member->Rank} successfully displays the rank number on it's own. Below 'should' translate that number into the name of the rank.

if('$RankNum' == 0) { echo('test1');};
if('$RankNum' == 1) { echo('test2');};
if('$RankNum' == 2) { echo('test3');};
if('$RankNum' == 3) { echo('test4');};
if('$RankNum' == 4) { echo('test5');};



[The Problem]
All this code keeps displaying "test1" for every value in the entire column, regardless if it equaled 1 or 2 or higher... I know this has to be some simple coding mistake, but I've been sitting here for an hour trying to figure out what I had done wrong.

Thanks in advance :)