Chat post showing from revers orde(lavalariar help)

[Ponick]

Hi every one,
in chat room we can fix the limit of chat post by changing
$counter=0; or if($counter<20) to our needed amount like if we change it to if($counter<10) then it will show 1-10 post in room.
But now if i don't want to show first post.I want to show like 2-10 post in room and first post is be hidden.
Then what to do ? Please somebody help

[strikingv]

Hi every one,
in chat room we can fix the limit of chat post by changing
$counter=0; or if($counter<20) to our needed amount like if we change it to if($counter<10) then it will show 1-10 post in room.
But now if i don't want to show first post.I want to show like 2-10 post in room and first post is be hidden.
Then what to do ? Please somebody help

if($counter<10 && $counter!=1)

[Ponick]

Its showing only 1 post in room

i want to show 2nd post to 10 post . 1st post will be not shown . Please help

[comando]

make a select with limit 2 to 10
select message from room order by timesent desc limit 2 ,10

[Ponick]

make a select with limit 2 to 10
select message from room order by timesent desc limit 2 ,10

with mysql?? but im very wk in sql

do me a favr please........ create dis code

[Vayne]

$sql = mysql_fetch_array(mysql_query("SELECT msg, user, id FROM chatmsg WHERE uid='".$changable."' ORDER BY id DESC LIMIT 2, 10"));


or smth...

[Ponick]

$sql = mysql_fetch_array(mysql_query("SELECT msg, user, id FROM chatmsg WHERE uid='".$changable."' ORDER BY id DESC LIMIT 2, 10"));


or smth...

thank you thank you thank you thank you thank you sooo much mwaaah Vayne n comando