Jump to content

korrupt03

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

korrupt03's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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:
  2. 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
×
×
  • Create New...

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.