1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Boston MA USA
    Rep Power
    This is a ponderment in have
    I'm building a news engine for my website using MySQL/PHP
    i have my table (date, time, comment, body) for submissions

    now i was thinking of sticking in ID...
    and having php grab by 4, 3, 2, 1, 0 in that order as autoassigning an id starts at 0 and goes up

    *is* *this* *possible*?!
    or do i have to figure out another way of doing this? :



  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    Select * from table_name order by id desc limit 5;

Similar Threads

  1. Replies: 0
    Last Post: October 23rd, 2003, 05:46 PM
  2. select in a select box by typing??
    By ihugo in forum HTML Programming
    Replies: 1
    Last Post: October 21st, 2003, 10:57 AM
  3. select across multiple tables (UNION)
    By vickistanfield in forum MySQL Help
    Replies: 3
    Last Post: September 26th, 2003, 08:05 PM
  4. SELECT something FROM (SELECT something2 FROM ...) ...
    By loudo in forum Firebird SQL Development
    Replies: 3
    Last Post: August 21st, 2003, 04:27 AM
  5. select box changes other select box...
    By etherwolf in forum PHP Development
    Replies: 6
    Last Post: October 11th, 2001, 11:29 AM

IMN logo majestic logo threadwatch logo seochat tools logo