MySQL/Join/DESC issues

mscribner

I have this query

//Connects to database  

$db = mysql_connect("$server", "$username", "$password");  mysql_select_db("$database",$db);  

//Checks for a search and prepares to do a query to the database.  

$result = mysql_query(  

"SELECT * FROM items, newitems WHERE  

items.ItemID = newitems.ItemID AND  

items.ID = newitems.ID AND 
items.Brand = newitems.Brand AND  

newitems.NCategory='$NCategory' 
ORDER BY newitems.tt DESC;  ", $db);  

$myrow = mysql_fetch_array($result);

what this is supposed to do is to list the output by its TimeStamp in a descending order. But when i run this code it gives me the order in which it is in the newitems database. what have i done wrong??? When i connect to MySQL and run the query, it gives me what i need.

LordShryku

Ditch the terminator and try it.

$sql = "SELECT * 
          FROM items, newitems 
         WHERE items.ItemID = newitems.ItemID 
           AND items.ID = newitems.ID 
           AND items.Brand = newitems.Brand 
           AND newitems.NCategory='$NCategory'
      ORDER BY newitems.tt DESC"; 
$result = mysql_query($sql);

mscribner

didn't do it.

Sxooter

What type is the field newitems.tt? Is it a date or datetime field? Or varchar / text?

mscribner

newitems.tt

newitems is the database that I'm pulling tt from and tt is the date field

Sxooter

Yes, it has the date, but is its type date, or text?

Because if it's a text type, it won't get sorted the way you expect it to.

mscribner

this is how i have it set

<input type="hidden" name="tt" size="30" value="<? echo date('Y-m-d') ?>

then everything is inserted into the database at once.

the tt field type is set to Date.