Jump to content

Archived

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

korrupt03

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.