Private Messaging [PHP]

[wsg14]

Aside from the **** that's been posted, I was actually focusing on this:

SELECT * FROM `private_messages` WHERE `'".$u->."'id` = '".$sess_id."' ORDER BY date DESC

How would I make it so I could add $u->id ($u being a whole different query, and id is gradding the `id` data from that query) into the query above?

[Hypertext]

I don't really understand what you want to do, but if it's get $u->id it'll be

SELECT * FROM `private_messages` WHERE `{$u->id}` = '{$sess_id}' ORDER BY date DESC

Can you elaborate on what the variables are, and what you want to do.

[wsg14]

Never mind, I got it.

Thanks Denta for the only contributing post (that helped, and the one above from Charlie) in this thread.

[Dentafrice]

SELECT * FROM `private_messages` WHERE `uid`='$sess_id' ORDER BY date DESC 

If $u->id is from a different query, can you post that?

@edit: Just saw your post, what was wrong?

[wsg14]

I had:

mysql_query("SELECT * FROM `private_messages` WHERE $u->id = '".$sess_id."' ORDER BY date DESC"); 

When really it should be (what it is currently):

mysql_query("SELECT * FROM `private_messages` WHERE `'".$u->id."' = '".$sess_id."' ORDER BY date DESC"); 

What would I do if I wanted to only display messages from a single person, I know that's what that code should accomplish but...

All that is going to do is fetch private_messages where the user's id = the logged in user's id. How would I make it so that it'll only grab the PM's which have that user's id - because the private messages table doesn't even have any refrence to a user id. (that most likely doesn't make sense)

So what I'm trying to say is: it will not fetch the private messages for the user that's logged in.

EDIT: Once again, got it.

[wsg14]

Yay, another problem! (well not a problem, but w.e)

$today = date("m.d.Y");
$yesterday = ($today--); 

I know you can do $variable++; but can you do $variable--;?

What I'm trying to do is said in the variable name, $yesterday. I'm trying to make it grab the date, but make it negative one so it displays yesterday's date. Is that the right way to do it? If not what is the right way?

[Dentafrice]

I'm not going to tell you how to do it.

You try it first

[Protege]

Using mktime and date, PHP.net give you a basic outline of it on their func date page.

Dont look if you dont want me to give it away to you.

Show Hide

<?php
$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"),   date("Y"));
$nextyear  = mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+1);
?>

That'll basically produce a timestamp (unix) which you can convert using date.

eg:

<?php
$yesterday = mktime( 0, 0, 0, date( 'm' )  , date( 'd' ) - 1, date( 'y' ) );
$yesterdays_date = date( 'm.d.Y', $yesterday );
echo( $yesterdays_date );
?>

[wsg14]

Thanks Protege, but found the mktime documentation on PHP.net earlier.

Just hitting one problem that;s stopping me from continuing.

<?php

$query = mysql_query("SELECT * FROM `private_messages` WHERE `to` = '".$sess_username."' ORDER BY date DESC");
$display = mysql_fetch_array($query);
$pm_count = mysql_num_rows($query);
$today = date("m.d.Y");
$yesterday - mktime(0, 0, 0, date( 'm' )  , date( 'd' ) - 1, date( 'y' ));

if($pm_count == 0){
    echo 'You do not have any messages at this time.';
} else{
    if($query->send_date == $today){
        echo '<b>Today</b><br />';
        if(!$read == 0){
            echo '<b>$display[\'name\']</b> - $display[\'from\']<br />';
        } else {
            echo '$display[\'name\'] - $display[\'from\']<br />';
        }
    }
    if($query->send_date == $yesterday){
        echo '<b>Yesterday</b>';
        if(!$read == 0){
            echo '<b>$display[\'name\']</b> - $display[\'from\']<br />';
        } else {
            echo '$display[\'name\'] - $display[\'from\']<br />';
        }
    }
    
}

?>

Error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kolzy/public_html/ws/private.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kolzy/public_html/ws/private.php on line 22

Line 21:

$display = mysql_fetch_array($query); 

Line 22:

$pm_count = mysql_num_rows($query); 

I tried using a while statement, that got rid of the first error but not the error for line 22. Would I use two while statements?

[Tom-743]

Because its going to be selecting more than 1 pm you need to use while;

$pm_count = mysql_num_rows($query);
$today = date("m.d.Y");
$yesterday - mktime(0, 0, 0, date( 'm' )  , date( 'd' ) - 1, date( 'y' ));

if($pm_count == 0){
    echo 'You do not have any messages at this time.';
} else{
  while ( $display = mysql_fetch_array ( $query ) ) {
     if($query->send_date == $today){
         echo '<b>Today</b><br />';
         if(!$read == 0){
             echo '<b>$display[\'name\']</b> - $display[\'from\']<br />';
         } else {
             echo '$display[\'name\'] - $display[\'from\']<br />';
         }
     }
     if($query->send_date == $yesterday){
         echo '<b>Yesterday</b>';
         if(!$read == 0){
             echo '<b>$display[\'name\']</b> - $display[\'from\']<br />';
         } else {
             echo '$display[\'name\'] - $display[\'from\']<br />';
         }
  }
} 

EDIT: allso i may be wrong but i dont think the variables in that will work becuase of the \ in them;

echo '$display[\'name\'] - $display[\'from\']<br />'; 

If you were getting a error before you changed it u should have changed it to this;

echo $display['name'] . " - " . $display['from'] . "<br />";