subject:"\[PHP\] SQL Hell"

Re: [PHP] SQL Hell

2004-04-21 Thread Curt Zirzow

* Thus wrote Marc Greenstock ([EMAIL PROTECTED]): > Hi all, > > Wondering if someone could help me with an sql statement > > MySQL version 4.0.18 > > I have three tables: > 1. visitor_data (Visitor_ID, IP Address) > 2. visit_data (Visit_ID, Visitor_ID) > 3. page_data (Page_ID, Visit_

[PHP] SQL Hell

2004-04-21 Thread Marc Greenstock

Hi all, Wondering if someone could help me with an sql statement MySQL version 4.0.18 I have three tables: 1. visitor_data (Visitor_ID, IP Address) 2. visit_data (Visit_ID, Visitor_ID) 3. page_data (Page_ID, Visit_ID, Visitor_ID, URI) If you look closely you can see the relationship