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

    Join Date
    Jul 2000
    Location
    Boston MA USA
    Posts
    23
    Rep Power
    0
    This is a ponderment in have
    I'm building a news engine for my website using MySQL/PHP
    now....
    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? :

    thnx

    Ted

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

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

Similar Threads

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

IMN logo majestic logo threadwatch logo seochat tools logo