RE: [PHP] RE: non-auto increment question

2009-02-25 Thread Jerry Schwartz
record that has an auto-increment field, you can retrieve the value that got inserted with "SELECT LAST_INSERT_ID()". It is connection-specific, so you'll always have your "own" value. You can then save it to reuse, either as a session variable or (more easily) as a hidden f

RE: [PHP] RE: non-auto increment question

2009-02-25 Thread Jerry Schwartz
ry, >accessed by user/password login... so there's really very little >possibility of 2 people accessing at the same time. [JS] Being rather old to all this, I can tell you that if something is even remotely possible it will happen just before your performance review. Never depend u

RE: [PHP] RE: non-auto increment question

2009-02-26 Thread Jerry Schwartz
>-Original Message- >From: PJ [mailto:af.gour...@videotron.ca] >Sent: Thursday, February 26, 2009 11:27 AM >To: Jerry Schwartz >Cc: a...@ashleysheridan.co.uk; 'Gary W. Smith'; 'MySql'; php- >gene...@lists.php.net >Subject: Re: [PHP] RE: non-auto i

[PHP] RE: catch the error

2009-02-26 Thread Jerry Schwartz
>-Original Message- >From: PJ [mailto:af.gour...@videotron.ca] >Sent: Thursday, February 26, 2009 12:28 PM >To: php-general@lists.php.net; MySql >Subject: catch the error > >What is wrond with this file? same identical insert works from console >but not from this file :-( > > > >Untit

RE: [PHP] RE: non-auto increment question

2009-02-26 Thread Jerry Schwartz
e specific database changes. You can make yourself more independent of the specific database by using the PDO abstraction, although I would save that for a rainy weekend. Regards,   Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032   860.674.8796 / FA

RE: [PHP] RE: non-auto increment question

2009-02-26 Thread Jerry Schwartz
Sorry, I should know better. >-Original Message- >From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] >Sent: Thursday, February 26, 2009 1:51 PM >To: Jerry Schwartz >Cc: 'PJ'; 'Gary W. Smith'; 'MySql'; php-general@lists.php.net >Su

[PHP] RE: Good source for sample data?

2010-01-29 Thread Jerry Schwartz
tion as part of security screening for a registration system. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >-Original Message- >From: Shawn McKenzie [mailto

[PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread Jerry Schwartz
#x27;10.%') or tag_number LIKE ('10.05%') and so forth. This scheme is infinitely extendable. To get the entire hierarchy, you simply SELECT tag_number, tag_name FROM tags ORDER BY tag_number; Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington,

[PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread Jerry Schwartz
>-Original Message- >From: Dotan Cohen [mailto:dotanco...@gmail.com] >Sent: Thursday, January 20, 2011 11:25 AM >To: Jerry Schwartz >Cc: mysql.; php-general. >Subject: Re: Organisational question: surely someone has implemented many >Boolean values (tags) and a solutio

RE: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

2011-01-20 Thread Jerry Schwartz
adds or subtracts 2 >from an int) then it looks to be a pain to add nodes. > [JS] Not at all. Somebody, somehow, has to assign a name to the tag and designate its place in the hierarchy. I don't see how you can avoid that being done by a human. Regards, Jerry Schwartz Global Information