[PHP] Re: SQL Hell

2004-04-21 Thread Marc Greenstock
> Alternatively, use a better database :) > Firebird has had Triggers and Stored Procedures from the start. Using > these with PHP gives the power needed to update cross references without > having to build complex PHP code. > http://www.firebirdsql.org/ I just downloaded and installed fire bird,

[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

Re: [PHP] Apple Mac Power PC problem

2004-04-01 Thread Marc Greenstock
Apache defaults to only allowing index.html or index.htm as a default directory page, you need to add index.php to the configuration file. On Apr 1, 2004, at 3:24 AM, Marc Greenstock wrote: > Hi all, > > I noticed on a clients Apple Mac Power PC that his php driven website > wasn&#x

[PHP] Apple Mac Power PC problem

2004-04-01 Thread Marc Greenstock
Hi all, I noticed on a clients Apple Mac Power PC that his php driven website wasn't working for him. It wasn't loading up at all, in fact it was returning an error that the URL could not be found. I discovered a quick fix for the problem, that is to create a index.html file and run a meta refres

Re: [PHP] apache lookdown

2004-03-11 Thread Marc Greenstock
eloper > [EMAIL PROTECTED] > www.chieftain.com > 1-800-279-6397 x 207 > > > > -Original Message- > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 11, 2004 1:36 AM > To: [EMAIL PROTECTED] > Subject: [PHP] apache lookdown > > Hi all

[PHP] apache lookdown

2004-03-11 Thread Marc Greenstock
Hi all, A long time ago I became accustomed to writing my php navigation structure using what I think is called apache lookdown (correct me if im wrong). Basically what it does is when a user types in www.example.com/index.php/doc/1/ apache checks to see if there is a directory called index.php/d

Re: [PHP] Let's start a php-advanced list!

2004-03-06 Thread Marc Greenstock
Interesting topic, However I don't necessarily agree that newbie's wont get their question answered. There are a lot of helpfully people out there, a lot of them are advanced in their programing but find the satisfaction of helping, or mentoring someone into advanced programming who is less ad

[PHP] Re: sql expression

2004-02-21 Thread Marc Greenstock
Ok I spoke too soon, I did this: SELECT * FROM users WHERE ((MONTH(user_data.User_DOB) * 100) + DAYOFMONTH(user_data.User_DOB)) BETWEEN 521 AND 621 as in I multiplied MONTH with 100 and added the DAYOFMONTH Marc. "Marc Greenstock" <[EMAIL PROTECTED]> wrote in message news:

[PHP] sql expression

2004-02-21 Thread Marc Greenstock
Hi all, I am trying to provide a star sign search so that the user can search for any given star sign eg Gemini and retrieve all the users who belong to that sign. I have a table with all the star signs, in the table are the fields 'Name','From','To'. Both the 'From' and 'To' are an integer of th

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
_data.Default_Img in ('Yes', '') > GROUP BY user_data.User_ID > > hope this works for you, good luck, > > Warren Vail > > > -Original Message- > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 10, 2004 6

Re: [PHP] SQL help

2004-02-10 Thread Marc Greenstock
t; do some reading up on how to do it... > > HTH > Martin > > > > -Original Message- > > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, 11 February 2004 1:53 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP] SQL help

[PHP] SQL help

2004-02-10 Thread Marc Greenstock
Hi all here's my problem, I have two tables: 'user_data' and 'image_data' obviously user_data has all the user information and image_data has all the image information in image_data are the fields: Image_ID int(11), User_ID int(11) and Default_Img enum('Yes','No'). Users can have as many images

[PHP] IRCG - php windows extension HELP!

2004-01-20 Thread Marc Greenstock
I'm trying to install IRCG as an extension to my Apache 2 PHP server running on Windows XP. Trouble is IRCG for windows comes as a standalone package, that doesn't seem to load in as an extension to php declaired in php.ini. I've typed in all the extensions but i continue to get an error for each

[PHP] Re: Flash-PHP Socket Connection

2004-01-20 Thread Marc Greenstock
I am doing the same thing at the moment, I'm building a Flash/PHP/MySQL chat system capable of handling over 1000 users online at one time. GET and POST just doesn't cut it, so I began to explore other avenues, and XML Socket's seem like the best and only option. But I expect to burn the midnight