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

  • From: "Sina Bahram" <sbahram@xxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 1 May 2009 14:07:30 -0400

Someone else already answer #2.

Tyler, for #1, lookup and learn, and then implement ajax.  There are several
PHP ajax frameworks, and it will facilitate exactly what you want.

It's easy to do ... It'll take you like a day, maybe two.

Take care,
Sina
 

________________________________

From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Tyler
Littlefield
Sent: Friday, May 01, 2009 11:51 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: web-dev questions with mysql, php, and others


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
My programs don't have bugs, they're called randomly added features.


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

Other related posts:

  1. Home
  2. programmingblind
  3. Archive
  4. 05-2009