[RESOLVED] Looking for some help!!

[kkwilliam]

Hi all I am new at this. I have made this code it works but I need to add to it or make it more simple can anyone out there help me?

Everything works. But I need help making result1 and result 2 goto another page if the mem_id_to is grade 3 or 4. There will be 2 more options for result1 and result2.

<?php
include('../../include/csm.php');

if(isset($_POST['submit'])){

// Check matching of members and grade.
  $result1 = mysql_query("SELECT * FROM users WHERE mem_id='$mem_id' and grade='1'");
  $result2 = mysql_query("SELECT * FROM users WHERE mem_id='$mem_id' and grade='2'");
  $result3 = mysql_query("SELECT * FROM users WHERE mem_id='$mem_id' and grade='3'");
  $result4 = mysql_query("SELECT * FROM users WHERE mem_id='$mem_id' and grade='4'");
  if($result1 || $result2 || $result3)
  {
   //pending members IF GRADE IS 3 OR 4 SEND TO ANOTHER PAGE
   if($result1)
   {
    while($row = mysql_fetch_array($result1))
    {
     $grade = $row["grade"];
     {
	  session_register("mem_id");
      $_SESSION['mem_id'] = $mem_id;
      $_SESSION['grade'] = "1";
      header("location:/mail/ps_mail/membermail_sentps.php");
      }
     }
    }
   //standard member IF GRADE IS 3 OR 4 SEND TO ANOTHER PAGE
   if($result2)
   {
    while($row = mysql_fetch_array($result2))
    {
     $grade = $row["grade"];
     {
      session_register("mem_id");
	  $_SESSION['mem_id'] = $mem_id;
      $_SESSION['grade'] = "2";
      header("location:/mail/s_mail/membermail_sents.php");
      }
     }
    }
   //gold member
   if($result3)
   {
    while($row = mysql_fetch_array($result3))
    {
     $grade = $row["grade"];
     {
	  session_register("mem_id");
      $_SESSION['mem_id'] = $mem_id;
      $_SESSION['grade'] = "3";
      header("location:/mail/g_mail/membermail_sentg.php");
      }
     }
    }
   //platnium member
   if($result4)
   {
    while($row = mysql_fetch_array($result4))
    {
     $grade = $row["grade"];
     {
      session_register("mem_id");
	  $_SESSION['mem_id'] = $mem_id;
      $_SESSION['grade'] = "4";
      header("location:/mail/p_mail/membermail_sentp.php");
      }
     }
    }
   if($_SESSION['mem_id'] != "ok")
   {
    $message="Incorrect Member No or Password";
    }
   }

$mem_id_from    =   $_SESSION['mem_id'];
$mem_id_to      =   addslashes($_POST['mem_id_to']);
$subject        =   addslashes($_POST['subject']);
$message        =   addslashes($_POST['message']); 
$date           =   date(YmdHis);
$type           =   ('email');



$create = "INSERT INTO mail (mem_id_to, mem_id_from, subject, message, sentdate, status, type, grade) 
VALUES ('$mem_id_to','$mem_id_from','$subject','$message','$date','unread', '$type', '$grade')"; 
$create2 = mysql_query($create) or die("A letter could not be sent to $mem_id_to!"); 


}
?>

[ ModEdit - bpat1434 ] Please use [php] tags when posting PHP code.

[bpat1434]

Why not make your life easier, run one query and get the result row:

$query = "SELECT * FROM `users` WHERE `mem_id`='$mem_id'";
$result = mysql_query($query) or die('MySQL Error: ' . mysql_error());
while($row = mysql_fetch_array($result))
{
    if($row['grade'] == '3' || $row['grade'] == '4')
    {
        // REdirect to another page...
    }
}

Tha'ts much simpler than 4 queries, 4 different results, and checking each result individually.

[kkwilliam]

Thank you bpat1434, your code helps a lot. But it dosen't take care of my problem. Below is what I need result1, result2 to do. Can you help? Thank you in advance. Sorry if I didn't explain well.

<?php
$mem_id_from = $SESSION['mem_id'];
$mem_id_to = addslashes($POST['mem_id_to']);

Here is my problem:

For result1
If mem_id_from = grade= 1
while mem_id_to = grade=1
// REdirect to here...
header("location:/mail/ps_mail/membermail_sentps.php");

If mem_id_from = grade= 1
while mem_id_to = grade=2
// REdirect to here...
header("location:/mail/ps_mail/membermail_sentps.php");

If mem_id_from = grade= 1
while mem_id_to = grade=3
// REdirect to here...
header("location:/mail/ps_mail/membermail_sentg.php");

If mem_id_from = grade= 1
while mem_id_to = grade=4
// REdirect to here...
header("location:/mail/ps_mail/membermail_sentp.php");

result2
If mem_id_from = grade= 2
while mem_id_to = grade=1
// REdirect to here...
header("location:/mail/s_mail/membermail_sents.php");

If mem_id_from = grade= 2
while mem_id_to = grade=2
// REdirect to here...
header("location:/mail/s_mail/membermail_sents.php");

If mem_id_from = grade= 2
while mem_id_to = grade=3
// REdirect to here...
header("location:/mail/s_mail/membermail_sentg.php");

If mem_id_from = grade= 2
while mem_id_to = grade=4
// REdirect to here...
header("location:/mail/s_mail/membermail_sentp.php");

[bpat1434]

Okay, so I'm going to take 1 instance, and you can apply it to all of them:

You have:

If mem_id_from = X
while mm_id_to = Y
header("location:/mail/..../membermail_....php");

That can change into:
if($mem_id_from == 'X' && $mem_id_to == 'Y')
{
header('Location: /mail/..../membermail_....php');
}

Hope that helps..

[kkwilliam]

Hello all!!! Thank you Brett(bpat1434) I am still having a problem. I will be so happy to have this work correct.

section #1 works until I add section #2
After I add section #2 and send using $SESSION['grade'] = "1" it skips section #1 and Redirects using section #2 which tells me its not reading the $SESSION['grade'] = "1". But if I send using a $_SESSION['grade'] = "2" it works.

Can you help me again..... Thank you so much......

<?php
include('../../include/csm.php');

if(isset($_POST['submit'])){

$query = "SELECT * FROM users WHERE mem_id='$mem_id_to'";
$result = mysql_query($query) or die('MySQL Error: ' . mysql_error());
while($row = mysql_fetch_array($result))
{
if($row['grade'] == '')
// section #1 This section of code works until I add section #2
// I think the problem is its not reading the $SESSION['grade']
// When I add section #2 and send using a $SESSION['grade'] ="1" it goes to #2 section which is wrong.
$SESSION['grade'] = "1";
IF ($row['grade'] == '1') {
header("location:/mail/ps_mail/membermail_sentps.php");
}
ELSEIF ($row['grade'] == '2') {
header("location:/mail/ps_mail/membermail_sentps.php");
}
ELSEIF ($row['grade'] == '3'){
header("location:/mail/ps_mail/membermail_sentpsg.php");
}
ELSEIF ($row['grade'] == '4'){
header("location:/mail/ps_mail/membermail_sentpsp.php");
}
// section #2 This section of code works if I log in using $SESSION['grade'] ="2"
$_SESSION['grade'] = "2";
IF ($row['grade'] == '1') {
header("location:/mail/s_mail/membermail_sents.php");
}
ELSEIF ($row['grade'] == '2') {
header("location:/mail/s_mail/membermail_sents.php");
}
ELSEIF ($row['grade'] == '3'){
header("location:/mail/s_mail/membermail_sentsg.php");
}
ELSEIF ($row['grade'] == '4'){
header("location:/mail/s_mail/membermail_sentsp.php");
}
}

$mem_id_from = $SESSION['mem_id'];
$mem_id_to = addslashes($POST['mem_id_to']);
$subject = addslashes($POST['subject']);
$message = addslashes($POST['message']);
$date = date(YmdHis);
$type = ('email');

$create = "INSERT INTO mail (mem_id_to, mem_id_from, subject, message, sentdate, status, type, grade)
VALUES ('$mem_id_to','$mem_id_from','$subject','$message','$date','unread', '$type', '$grade')";
$create2 = mysql_query($create) or die("A letter could not be sent to $mem_id_to!");

}
?>

[kkwilliam]

Hello Brett and all...........

While reading my last post I figured out how to do what I needed to have done. I have now included a new mail_function for each $_SESSION['grade'] and it works....

Thank you so much for helping me out.......

[bradgrafelman]

Don't forget to mark this thread resolved.