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 (http:

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)

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 ou

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 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