Jump to content


This topic is now archived and is closed to further replies.


Puzzling MySQL Error

Recommended Posts

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:


8) KoRRupt

Share this post

Link to post
Share on other sites

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";

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.