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