[PHP] running number in paging

2006-06-29 Thread weetat
Hi all , I have using PEAR:Pager , to do paging . Everthing are ok . Except the running no will always start from 1 to 10 . Anyway to increase the running number when user click next page for example Page 1 : 1 to 10, Page 2 : 11 to 20, and so on Thanks below is the code , the

Re: [PHP] running number in paging

2006-06-29 Thread Chris
weetat wrote: Hi all , I have using PEAR:Pager , to do paging . If you have a pear question, ask on the pear mailing list. http://pear.php.net/support/ We do not know their code or how to use it. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List

[PHP] running number

2005-07-25 Thread Roger Thomas
I am required to write a user registration script that captures the basics like name, phone number etc etc. I would also have to write to mySQL database a number that is associated with that user. At this point of writing, the start of that number is unknown. But the number will be incremented

Re: [PHP] running number

2005-07-25 Thread Richard Davey
Hello Roger, Monday, July 25, 2005, 10:21:54 AM, you wrote: RT I am quite new at all these stuff and would like to seek your RT advise on the *recommended way* of achieving this. I am thinking RT along these lines: RT a) store that number (12345) in a table RT b) a user registers and assign that

Re: [PHP] running number

2005-07-25 Thread Sascha Kaufmann
try mySQL's auto increment attribute http://dev.mysql.com/doc/mysql/en/example-auto-increment.html Roger Thomas wrote: I am required to write a user registration script that captures the basics like name, phone number etc etc. I would also have to write to mySQL database a number that is

Re: [PHP] running number

2005-07-25 Thread Robert Sossomon
CREATE TABLE `users` ( `num` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `login` varchar(100) NOT NULL default '', `password` varchar(20) NOT NULL default '', PRIMARY KEY (`num`), KEY `num` (`num`) ) TYPE=MyISAM AUTO_INCREMENT=12345 ; That should help

Re: [PHP] running number

2005-07-25 Thread Roger Thomas
Thanks to all that have helped. I am inclined at Robert's suggestion below that would free me from worrying about locking issues. Thanks everybody. -- Roger Quoting Robert Sossomon [EMAIL PROTECTED]: CREATE TABLE `users` ( `num` int(10) NOT NULL auto_increment, `name` varchar(100) NOT