Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread Jon Baer
Another pretty cool option would be to use PECL's xdiff w/ the db content ... Table it w/ created_at, updated_at, content http://us2.php.net/manual/en/function.xdiff-string-diff.php Haven't had a chance to check it out but would be able to show changes over time. - Jon On Jun 27, 2007, a

Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread David Krings
Steve Francia wrote: The version table would have the document_id, content and the mod_date and author_id. I am by no means a database expert, but why would one want to store guaranteed to be static data in a table such as the content. That content will never ever change. I agree with all oth

Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread Steve Francia
If it is just for a single document you can do it pretty easily with just sql (mysql). Make a document table and a version table. The document table would have the shell of what a document was (title, etc). The version table would have the document_id, content and the mod_date and author_id. To

Re: [nyphp-talk] Web contact form -- email or database?

2007-06-27 Thread Kenneth Downs
Cliff Hirsch wrote: Appreciate thoughts on contact/help forms on a web site: Options: 1. Directly send email to admins 2. Store form in database for online viewing by admins Thoughts? Email is simplest --- the infrastructure is in place. But storing the form in a database is more power

Re: [nyphp-talk] Web contact form -- email or database?

2007-06-27 Thread Rolan Yang
I usually email. AND append the data to a local ascii file. On 6/27/07, Cliff Hirsch <[EMAIL PROTECTED]> wrote: Appreciate thoughts on contact/help forms on a web site: Options: 1. Directly send email to admins 2. Store form in database for online viewing by admins Thoughts? Email is simplest

Re: [nyphp-talk] Web contact form -- email or database?

2007-06-27 Thread Ben Sgro \(ProjectSkyline\)
Web contact form -- email or database?Hello, What's the budget? Like you said, email is quick and works. DB is the better choice...but what does the budget permit? If you don't have the money, convince them of why the DB is better. Its somehting that is an easy sell to my clients when we discu

[nyphp-talk] Web contact form -- email or database?

2007-06-27 Thread Cliff Hirsch
Appreciate thoughts on contact/help forms on a web site: Options: 1. Directly send email to admins 2. Store form in database for online viewing by admins Thoughts? Email is simplest ‹ the infrastructure is in place. But storing the form in a database is more powerful. Allows analysis, history, lo

[nyphp-talk] optional vs. mandatory account creation

2007-06-27 Thread Jeremy Campbell
has anyone come across any worthwhile analysis of optional vs. mandatory account creation in shopping carts. i'm sure it varies by demographic, but i'm curious if the amount of customers you'd lose by making it mandatory is at all significant. thanks, jeremy ___

Re: [nyphp-talk] [OT] migrating old site to cleaner URLs

2007-06-27 Thread Steve Francia
If you are using mod rewrite make sure you set the R=301, and don't forget to pass along the query string if you need to. RewriteRule ^oldurl$ /newurl [R=301,L] -Steve Francia On 6/27/07, Jon Baer <[EMAIL PROTECTED]> wrote: There is a script out there which will run through your 404 apache log

Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread Jon Baer
Subversion and WebSVN :-) http://websvn.tigris.org/ On Jun 27, 2007, at 12:43 PM, David Krings wrote: Jake McGraw wrote: Hi All, this is my first post, so if this is in the wrong section please let me know. I'd like to know if anyone has developed a database schema for storing the revision

RE: [nyphp-talk] [OT] Does anyone know how Google grouped links a re done?

2007-06-27 Thread Peter Sawczynec
Very nice google updates. Thanks. Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of inforequest Sent: Tuesday, June 26, 2007 7:31 PM To: talk@lists.nyphp.org Subject: Re: [nyphp-talk] [OT] Does anyone know how Google grouped links a re done? Good luck

Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread Rolan Yang
Jake McGraw wrote: Hi All, this is my first post, so if this is in the wrong section please let me know. I'd like to know if anyone has developed a database schema for storing the revision history for a plain text document by multiple users. Basically, I'm talking about a wiki, but something muc

Re: [nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread David Krings
Jake McGraw wrote: Hi All, this is my first post, so if this is in the wrong section please let me know. I'd like to know if anyone has developed a database schema for storing the revision history for a plain text document by multiple users. Basically, I'm talking about a wiki, but something muc

[nyphp-talk] DB Schema for storing revision history?

2007-06-27 Thread Jake McGraw
Hi All, this is my first post, so if this is in the wrong section please let me know. I'd like to know if anyone has developed a database schema for storing the revision history for a plain text document by multiple users. Basically, I'm talking about a wiki, but something much more simple. Any s

RE: [nyphp-talk] [OT] LAMP

2007-06-27 Thread m rutko
Hi Hans, For some reason the job list is not allowing me to post on it ,I'm not sure why? And since this is a great opportunity that I'm sure a lot of members would want to know about ,I tried "conversations" Thanks, Mike Hans Zaunere <[EMAIL PROTECTED]> wrote: Hi Mike,

RE: [nyphp-talk] [OT] LAMP

2007-06-27 Thread Hans Zaunere
Hi Mike, Thanks for the post. However, we do have a NYPHP-Jobs list for job related posts and conversation. http://lists.nyphp.org/mailman/listinfo/jobs Thanks, H m rutko wrote on Wednesday, June 27, 2007 11:38 AM: > Hi > I'm looking for mid level to senior level developers with LAMP > exper

[nyphp-talk] [OT] LAMP

2007-06-27 Thread m rutko
Hi I'm looking for mid level to senior level developers with LAMP experience for a long term project in Manhattan. Sorry no telecommuting, onsite only. Hourly rate is open. This is a great opportunity to be part of a very talented team in a company which is dedicated in using cutting edge techn

Re: [nyphp-talk] [OT] migrating old site to cleaner URLs

2007-06-27 Thread Jon Baer
There is a script out there which will run through your 404 apache log + put it into mod_rewrite recipes automatically, if I can dig up will post but Im sure it might also be trivial to write. I used this to clean up a switch over a few years back. - Jon On Jun 27, 2007, at 10:13 AM, Bren

Re: [nyphp-talk] [OT] migrating old site to cleaner URLs

2007-06-27 Thread Chris Shiflett
Marc Antony Vose wrote: > I've read that google ignores 302 redirection codes and doesn't > update its index, so I'm a bit at a loss as how to proceed. Use a 301: http://shiflett.org/blog/2007/jan/url-vanity Chris -- Chris Shiflett http://shiflett.org/ _

Re: [nyphp-talk] [OT] migrating old site to cleaner URLs

2007-06-27 Thread Brent Baisley
You probably want to look into Apache mod_rewrite, if you are running Apache. It will do exactly what you are looking for. The alternative is to put a php file in all of the "old" locations that is really just a single include line that loads the file from the new location you want to move

[nyphp-talk] [OT] migrating old site to cleaner URLs

2007-06-27 Thread Marc Antony Vose
Hi there: I have an old site that has been online for ~7 years, and it is established, if a bit old and crusty. It's a database-driven directory of products for the Mac, and it performs reasonably well in google's search results, and gets a fair amount of traffic. This site was built bef