PHP - Moved: Display Data By Alphabetical Order

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=321339.0

I have info being pulled from 2 tables, I need to know how I can order by date from both table intermixing.............like table 2 has the soonest timestamp, then table 1 has the next , then table 2 has the one after that, how do I make it display info in order of table 2 info, table 1 info, table 2, info...........here is code that I been trying to use:
Code: [Select]
<?php
include 'config.php';
include 'opendb.php';

// if no id is specified, list the available articles
if(!isset($_GET['id']))
{

   $query = "SELECT * FROM messages WHERE recipient ='$name' order by date desc";
   $result = mysql_query($query) or die('Error : ' . mysql_error());

   // create the article list
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
list($from1, $recipient, $title1, $content, $id, $date, $read) = $row;  
 if ($read == $userid){ 
$content1 .= 
"<br /><br />
$from1</p>\r\n";
$content2 .= "<br /><br />
<a href=\"/message.php?id=$id\">$title1</a>\r\n"; 
   }else{
$content1 .= 
"<br /><br />
<strong>$from1</strong></p>\r\n";
$content2 .= "<br /><br />
<a href=\"/message.php?id=$id\">$title1</a>\r\n"; 
   }}


   }else {
   // get the article info from database
   $query = "SELECT * FROM messages WHERE recipient='$name' ORDER by date desc";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

   $title = $row['title'];
   $content = $row['content'];
   $to = $row['recipient'];
   $from = $row['from1'];
   $id = $row['id'];
   $read = $row['read'];

}


// if no id is specified, list the available articles
if(!isset($_GET['id']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT * FROM comments WHERE recipient='$name' order by date desc";
   $result = mysql_query($query) or die('Error : ' . mysql_error());

   // create the article list
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($com_id, $userid, $id1, $id, $recipient, $comment, $sender, $title, $date, $read) = $row;
    
 if ($read == $userid){ 
$content1 .= 
"<br /><br />
$from1</p>\r\n";
$content2 .= "<br /><br />
<a href=\"/message.php?id=$id\">$title</a>\r\n"; 
   }else {
$content1 .= 
"<br /><br />
<strong>$from1</strong></p>\r\n";
$content2 .= "<br /><br />
<a href=\"/message.php?id=$id\">$title</a>\r\n"; 
   }}

} else {
   // get the article info from database
   $query = "SELECT * FROM comments WHERE recipient='$name' order by date desc";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

   $userid = $row['userid'];
   $id1 = $row['id1'];
   $id = $row['messageid'];
   $recipient = $row['recipient'];
   $comment = $row['comment'];
   $sender = $row['sender'];
   $title = $row['title'];
   $read = $row['read'];


}

include 'closedb.php';

?>

I have the following code which displays images and captions from a directory. I would like the images to be displayed in the order they were created. Somebody suggested I use glob(), but I have no idea how.


<?php
$dir = "exclusive_images/";
if ($opendir = opendir($dir)) {
 //read directory

 while(($file = readdir($opendir)) !==FALSE) {
if ( file_exists($dir.'/'.$file) && in_array( strtolower(pathinfo($file,PATHINFO_EXTENSION )), array('png','jpg','jpeg','gif'))) {
   if (file_exists($dir.'/'.$file. '.txt')) 
   $caption = file_get_contents($dir.'/'.$file. '.txt');
   else    $caption = ucwords(str_replace(array('-','_'),' ', substr($file, 0, (strlen ($file)) - (strlen (strrchr($file,'.'))))));
   echo '<tr><td><img src="' . $dir.'/'.$file .'" alt="'. $file .'" title="' . $file . '" width="200"></td><td>' . $caption . '</td></tr>';
  }
 }
}


?>

I have a posting system worked out, as well as my database configured to my linking.. But as of right now, my posts are posted from oldest to newest, having users scroll down or go to the next page to see the most recent post.   How would I "flip" that around and make my posts start from newest to oldest by its date/time (Which is stored in the database)?   Thanks!

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=321790.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355706.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318036.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=347726.0

Hi all!
I'm stuck in the midst of some code.
In it I have an if function which operates based on whether a variable (a word) is the same as another variable.
Here is my code:
Code: [Select]
<?
$var1 = "chicago";
if($table_name === $var1){
$result = mysql_query("SELECT * FROM another_table WHERE username='$usernamee'");
    while($row = mysql_fetch_array($result) )
    {
    $var2 = $row['var2'];
    $var2_new = $var2 * 2;
    mysql_query("UPDATE another_table SET var2 = '$var2_new' WHERE username = '$usernamee'");
    }
}
?>I tried using =, == and ===, but did not get any of the results I expected.

Could anyone advice me on the situation?
Thanks in advance.

Regards,
Thauwa

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319167.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=328735.0

This topic's house has been seized by the bank and it now lives in MySQL Help until it can get back on its feet.

http://www.phpfreaks.com/forums/index.php?topic=358035.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=326563.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=349226.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=320026.0