PHP - How To Order Mysql Results From Most Recent Entry In While Loop

How can I make this output in descending order from greatest to least? Right now, it appears like:

1940
1941
1942
1943
1944
etc...

i'd like it to be like

2012
2011
2010
2009
etc.. until it gets to 1940

any ideas?

here is my code:


<?
$i = 1939;
while ($i < 2012) {
$i++;
echo '<option value="'.$i.'">'.$i.'</option>';
}

?>

This topic has been moved to MySQL Help.

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

Newbie here, I am actually a math teacher working on creating a simulated store front for my students where they keep up with inventory, budgeting etc.

Everyday my students will have to look at how much product is in stock, how much product was sold, and then input how much should be ordered for the next day.

I am working on an answer key that will be used to validate students input but the 'quantity' and 'sold' fields will be relative to the most recent post. Right now the code below pulls all the rows under 'quantity', but I need it to only pull the most recent post.

I have done my best to search the forum and try to find how to do this, but admittedly I am not even really sure what to be searching for. Any help would be great.



Code: [Select]
<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("myDatabase", $con);

$result = mysql_query("SELECT * FROM myTable");

while($row = mysql_fetch_array($result))
  {
 $quantity = $row['quantity'];
 $sold = $row['numbersold'];
 $needed = $row['remaining'];
 echo $needed-($quantity-$sold);
  }

mysql_close($con);
?>

Hi guys,  Having problems sorting mysql results. I can easily order/sort table columns but would like to order the results by a variable.(Distance in Miles).
Havent much experience in PHP and really struggling with this. Basically a query echoing out car make and models and how far they are located from a postcode. Can get it to work no porblem, but not to order/sort by least distance.

Heres what i'm working with:
Code: [Select]
$res=mysql_query("SELECT * FROM cars");
while ($row = mysql_fetch_assoc($res)){

echo $row['Make'];
echo $row['Model'];

//variable will be determimed by user input form
$postcode="W12 3SR";

$start=$postcode;
$ends = array();

//finds value from database field
{
$ends[]=$row['Location'];
}

// Postcode entered by user via input form
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$start'");
while($row=mysql_fetch_array($result)){
$gridn[0]=$row['Grid_N'];
$gride[0]=$row['Grid_E'];
}

foreach($ends as $fin){
// Postcodes within mysql table
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$fin'");
while($row=mysql_fetch_array($result)){
$gridn[1]=$row['Grid_N'];
$gride[1]=$row['Grid_E'];
}

// TAKE GRID REFS FROM EACH OTHER TO WORK OUT DISTANCE.
$distance_n=$gridn[0]-$gridn[1];
$distance_e=$gride[0]-$gride[1];

// CALCULATE THE DISTANCE BETWEEN THE TWO POSTCODES AND DIVIDE BY 1.6 TO CONVERT KM TO MILES
$hypot=sqrt(($distance_n*$distance_n)+($distance_e*$distance_e))/1.609;

//VARIABLE FOR DISTANCE AND ROUNDED OF TO NEAREST WHOLE NUMBER.
$distance=''.round($hypot/1000,0).'';


  echo " $distance miles";
  echo "<br>";
}
}
?>
I wish i could just do something like this but isnt possible, is it ?
Code: [Select]
"Select * FROM cars ORDER BY $distance";
Thanks!

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.