Re: [nyphp-talk] Learning SQL - Resources & Recommendations

I tell everyone who's new to programming to join Safari books at the Premier Club on devx.com. For $15/month you have totally access to 10 books at one time (there's also other plans). And there's many SQL/MySQL/MS SQL books so you can start with the basics and advance from there. Susan ---

[nyphp-talk] Learning SQL - Resources & Recommendations

Hello Everyone, A friend of mine is trying to learn SQL and asked me for some resources to point her in the right direction as far as understanding SQL, table-driven designs, logic, etc. Does anyone have any recommendations? Thank you in advance. Sincerely, Nelly Yusupova Webgrrls International

Re: [nyphp-talk] Paging Strategies

On Thu, Oct 18, 2007 at 03:05:56PM -0400, Dell Sala wrote: > > 3) ONE QUERY, CACHE EVERYTHING This is the approach we use in the project I'm on. We store the results in an SQLite database. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensiv

Re: [nyphp-talk] Php file owner, group and permissions

On Tue, Oct 16, 2007 at 01:26:39PM -0400, Cliff Hirsch wrote: > > What is the best permission level? 644, 640? Files should be owned and only writable by an administrative level user. The web server should be run as an unprivileged user/group, which has read only access to the files. If your

Re: [nyphp-talk] Some comments on the XML Talk

> I don't have an answer yet. I'm mostly just musing on some > possibilities, and letting the ideas cook in my head for now. The tricky > bit is figuring out how to design this so that there aren't a lot of > confusing precedence rules for resolving conflicts between different > mappings, while sti

Re: [nyphp-talk] PHP5 hosting?

I say bluehost hands down. I wrote a review at my blog . Chris On 10/31/07, Ajai Khattri <[EMAIL PROTECTED]> wrote: > > On Wed, 31 Oct 2007, Jon Baer wrote: > > > Joyent > > http:

Re: [nyphp-talk] Some comments on the XML Talk

Elliotte Harold wrote: Tim Gales wrote: Valid XML documents must adhere to their DTD/Schema and to that degree they have fields -- called 'elements'. like Which is why we don't necessarily use valid XML documents. For many applications, well-formed is good enough. In practice, validation is

Re: [nyphp-talk] Mod Rewrite Issue

On 11/1/07, csnyder <[EMAIL PROTECTED]> wrote: > RewriteLog http://httpd.apache.org/docs/2.0/mod/mod_rewrite.html#rewritelog Thanks, Chris. Don't know why I didn't think of that:) Anyway, it turns out the issue was with my Apache config file. I had to change the AllowOverride setting. #Allo

Re: [nyphp-talk] Mod Rewrite Issue

On 11/1/07, Randal Rust <[EMAIL PROTECTED]> wrote: > How can I debug this? I'm sure it's something simple, I just don't > have enough experience with mod_rewrite to know what it is. TIA. RewriteLog http://httpd.apache.org/docs/2.0/mod/mod_rewrite.html#rewritelog -- Chris Snyder http://chxo.com/

[nyphp-talk] Mod Rewrite Issue

I am working to integrate clean URLs for a couple I sites that we manage and I know exactly what I need to do. However, I am having trouble getting the rewrite rules to work on my local test server. If I upload the .htaccess file to the live server, it works perfectly. I have mod_rewrite enabled o

Re: [nyphp-talk] Some comments on the XML Talk

Elliotte Harold wrote: By contrast, if you don't lock in any schema at all (as is possible with an XML DB) then you can adapt your data to meet changing and newly discovered requirements as they become apparent. You can also design and deploy your application in short iterations that progressiv

Re: [nyphp-talk] Some comments on the XML Talk

Kenneth Downs wrote: Finally, I would have liked to hear more of Rusty's ideas about the relationship between the file system, the web server, and the database. Rusty, do you want to expand on that here? Well in most applications, the database stores its data in the file system. However i

Re: [nyphp-talk] Some comments on the XML Talk

[EMAIL PROTECTED] wrote: This statement prompted my reason for replying. Is there a standalone set of tools for updating/editing an XML database? I'm thinking of something along the lines of Microsoft Access, where you have 1 tool which has forms, program logic, and a database and all the d

Re: [nyphp-talk] Some comments on the XML Talk

Tim Gales wrote: Valid XML documents must adhere to their DTD/Schema and to that degree they have fields -- called 'elements'. like Which is why we don't necessarily use valid XML documents. For many applications, well-formed is good enough. In practice, validation is usually one of the fir

Re: [nyphp-talk] Some comments on the XML Talk

ali mohammad wrote: At the risk of slightly sounding off topic (but it does base on Kenneth's question on specific examples), I would like anybody's views on the applicability of XML database to clinical databases where the information that needs to be stored comes from a domain that is largely