Re: web-dev questions with mysql, php, and others

awesome. I might put in a date too, just to add some flavor to it. My login wasn't working, and I got irrritated and just deleted the code; I'm restarting, but I should be to the posts by the end of spanish class, hopefully. 

Thanks,
Tyler Littlefield
Web: tysdomain.com
email: tyler@xxxxxxxxxxxxx
My programs don't have bugs, they're called randomly added features.
----- Original Message ----- From: "niran" <public.niran@xxxxxxxxx> 
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Friday, May 01, 2009 10:58 PM
Subject: Re: web-dev questions with mysql, php, and others
If I understand your MySQL quesstion correctly, Use something similar to below line 
select * from post_table order by pid desc limit 20;
The order by and limit are the key here.
However, I would create a date field to hold the post's creation date and sort descending on it rather than on the auto_increment ID field. 
HTH
Tyler Littlefield wrote:

Hello list,
I'm writing a little tiney bbs system, just for something to give a few people for an example on php. Basically what I want is to refresh somehow with the website so that the newest posts will come up, without refreshing the whole page and making jaws go crazy. 
How can this be achieved?
Second, I have a list in a table with poster's id, and their post with a pid (post id) that is auto_increment. The oldest message will be the lower id, so I need a way to sort it out with the highest id being the top, so from highest to lowest. Is there a way to do this when I request it from mysql? or do I just have to reverse the selection when I use php. I'm not sure how big this will get, but I'd also like to limit it say to max id-20. so it'd show from 100 to 120, if 120 was the max id, etc, rather than sending back all messages in a query when it gets to the point where there are hundreds in the system. 

Thanks,
Tyler Littlefield
Web: tysdomain.com
email: tyler@xxxxxxxxxxxxx <mailto:tyler@xxxxxxxxxxxxx>
My programs don't have bugs, they're called randomly added features.


__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind 



__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind

Other related posts: