DESC LIMIT 5 problem

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Spam sucks

    DESC LIMIT 5 problem

    Hello,

    I have a problem with the next query, it supposed to give 5 row's back but i
    gives just 2 row's back.The temptable with id=5 should give 15 row's back if
    there were no conditions. could somebody tell me what to do about this.

    $query6 =" SELECT * FROM temptableWHERE id=5 ORDER BY timestamp DESC LIMIT
    0,5";


    Thanks in advance

    G


  • Spam sucks

    #2
    Re: DESC LIMIT 5 problem

    i allready found the problem sorry for the post.

    G


    "Spam sucks" <nomail> schreef in bericht
    news:3f867be8$0 $58701$e4fe514c @news.xs4all.nl ...[color=blue]
    > Hello,
    >
    > I have a problem with the next query, it supposed to give 5 row's back but[/color]
    i[color=blue]
    > gives just 2 row's back.The temptable with id=5 should give 15 row's back[/color]
    if[color=blue]
    > there were no conditions. could somebody tell me what to do about this.
    >
    > $query6 =" SELECT * FROM temptableWHERE id=5 ORDER BY timestamp DESC LIMIT
    > 0,5";
    >
    >
    > Thanks in advance
    >
    > G
    >
    >[/color]


    Comment

    Working...