PHP - Mysql Reverse Order

Hello All
New here and could use a bit of help.

Basically I have 2 separate functions that echo their results out in an html page.
My problem is the first function needs a value from the second function after it has run but needs to be echoed before the second for aesthetics.

Here's a bit of code to explain.
Code: [Select]
  <div class="bag"><br/><?php echo writeShoppingCart(); ?> </div>
<div id="contents">
<?php
echo showCart();
?>
</div>
So basically to work correctly I need showCart to finishing before calling writeShoppingCart()
I tried doing a redirect to the same page but it didn't like that.
Is there another way around this that I'm not aware of?
I suppose I could write a third function to get the value I need and call it before but I was hoping for a something a little cleaner.

Cheers

Hi folks...

Trying to get a bit of gallery code to work the way I want it to and would appreciate some feedback from more experienced folks...

What it's doing, or is supposed to be doing, is taking a thumb called 'thumb.jpg' from each folder within my gallery folder and displaying it in reverse order on a page. I only want a maximum number of images to display on the page at any one time, so that if I end up uploading loads of folders in the future, it will only display a set amount of thumbs on one page.

I want the thumbs displayed in reverse order, so that the newest appears first.

Here's the code... and as far as I can see, it should work... and I'm sure I have had it working in the past (I've just come back to working on it after a while) however now, it's putting the thumbs in a random order.

My folders are all in the gallery folder, and are named 001, 002, 003, 004, 005, 006, etc.
I want them to display with 006 at the top and to de-increment, but only for the most recent 16 folders.

Code: [Select]

<?php

$images = "gallery/"; # Location of galleries 
$cols   = 4; # Number of columns to display 
$max     = 16; # Maximum number of galleries to show

if ($handle = opendir($images)) { 
   while (false !== ($file = readdir($handle))) { 
       if ($file != "." && $file != "..") { 
           $files[] = $file; 
       } 
   } 
   closedir($handle); 
} 

$colCtr = 0; 

echo "<div id=\"updates\"><table><tr>"; 

$c = count($files) - 1; //$c = the number of files in the array, minus 1 = highest index in the array.
for($i = $c; $i > ($c - $max); $i--) //$i = $c, $i is greater than the array count minus $max, $i de-increments on each loop.  This will give us a countdown for the number of galleries required.
{ 
  if($colCtr %$cols == 0) 
    echo "</tr><tr>"; 
  echo "<td><img src=\"" . $images . $files[$i] . "/thumb.jpg\" width=\"240px\" height=\"180px\" alt=\"" . $alt . "\" /></td>"; //echo'ing out the $file[$i] on the loop, will give us the last required number of files in the file array.
  $colCtr++; 
} 

echo "</table></div>" . "\r\n"; 

?>


I also want to work out how to set a start number for the galleries, so that I can paginate them... so, once I have 36 galleries (for example) I can have the latest 16 on the first page, and the next 16 on the 2nd page... and the 4 that run over would drift off into obscurity until I get round to deleting them... maybe with a variable named $min... How would I do that...? Like this, or differently? :

Code: [Select]

<?php

$images = "gallery/"; # Location of galleries 
$cols   = 4; # Number of columns to display 
$min     = 16; # Minimum number of galleries to show
$max     = 32; # Maximum number of galleries to show

if ($handle = opendir($images)) { 
   while (false !== ($file = readdir($handle))) { 
       if ($file != "." && $file != "..") { 
           $files[] = $file; 
       } 
   } 
   closedir($handle); 
} 

$colCtr = 0; 

echo "<div id=\"updates\"><table><tr>"; 

$c = count($files) - 1; //$c = the number of files in the array, minus 1 = highest index in the array.
for($i = $c; ($i + $min) > ($c - $max); $i--) //$i = $c, $i plus $min is greater than the array count minus $max, $i de-increments on each loop.  This will give us a countdown for the number of galleries required.
{ 
  if($colCtr %$cols == 0) 
    echo "</tr><tr>"; 
  echo "<td><img src=\"" . $images . $files[$i] . "/thumb.jpg\" width=\"240px\" height=\"180px\" alt=\"" . $alt . "\" /></td>"; //echo'ing out the $file[$i] on the loop, will give us the last required number of files in the file array.
  $colCtr++; 
} 

echo "</table></div>" . "\r\n"; 

?>


Any help greatly appreciated!

Hi all

I have an SQL database that holds dates in this format: yymmdd example: 110824

I am echoing the value:

Code: [Select]
<?php echo $showdata['date']; ?>

How do I reverse the string so it shows 240811 ?

Cheers
Pete

Hi all,


I have a MySQL table with the field 'number'.
When I SELECT * from that field, I get a return for the rows of 'number' in the order 1, 2, 3, 4, etc...
 

SELECT * FROM products;

Is there a way where I can get a return in the reverse order, so highest to lowest (4, 3, 2, 1, etc...)?
Edited by Phaelon, 13 May 2014 - 03:23 AM.

Lets say I have this query:

$sql = mysql_query("SELECT * FROM Member ORDER BY posts DESC LIMIT 10");
while ($get = mysql_fetch_array($sql)){

$row .= $get['id'];
$posts .= $get['posts'];

echo "$row - $posts<br />";

}

Lets say I have two of rows, with posts fields of 84 and 803. When it displays it, it grabs the 84 row first, when I want the bigger number 803 first. Is there a way to fix this?