Puzzling MySQL Error

[korrupt03]

We\'ve got a problem on our hands.. :roll:

 

Well okay, I run a flash portal on my site, http://www.stickslaughter.com/ss/portal/ and the current arrangement for the Staff animations isn\'t working..

 

Okay, well, I am attempting to create a page where it displays a staff members 3 latest animations, (http://www.stickslaughter.com/ss/portal/stafftest.php), then display a link to show all of their animations.. but.. mySQL gives off a weird errors.. here\'s what I\'m trying..

 

$sql = "SELECT * FROM $table WHERE user_id = \'1\' DESC LIMIT 3";

 

I know the table, select, from, and where are right, plus user_id is the correct table.. but it gives off a weird error. I need to include the DESC, which is suppose to display it in Descending order, or backwards, because if I just use:

 

$sql = "SELECT * FROM $table WHERE user_id = \'1\' LIMIT 3";

 

... it displays the list of 3 animations, but it\'s in oldest to newest, which doesn\'t work...

 

user_id =\'1\' is correct, because the user_id 1 is a staff animators number...

 

But if I take off the DESC, it works...

 

So basically, is their anyway to put it in DESC order, but use a WHERE..

 

Help! :shock:

 

KoRRupt

[shivabharat]

Try this

 

substitue <filed_name> with what everr field you want to sort by.

 

$sql = "SELECT * FROM $table WHERE user_id = \'1\' order by <field_name> DESC LIMIT 3";

[korrupt03]

Perfect! Thank you so much man!

 

I used the code you suggested... and substituted the fieldname with movie_date_uploaded, which worked great!

 

Thank you my friend, your a great help to this world of ours...

 

Peace

 

P.S. If you care to see it all worked out, http://www.stickslaughter.com/ss/portal/stafftest.php :wink: