[PHP-DB] RE: Subject OUTER JOIN ( WAS Subject: Multiple SELECT)

2004-07-12 Thread Neil Smith [MVP, Digital media]
This answer is quite involved, see below. Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 To: [EMAIL PROTECTED] Date: Sun, 11 Jul 2004 19:31:21 -0700 From: "Marcjon" <[EMAIL PROTECTED]> Message-Id: <[EMAIL PROTECTED]> I know this issue comes up alot,

[PHP-DB] Re: $_SERVER['HTTP_REFERRER']

2004-07-12 Thread pete M
I think its either $_SERVER['HTTP_REFERER'] and not $_SERVER['HTTP_REFERRER'] [EMAIL PROTECTED] wrote: For some reason I cannot get this to work. I'm trying to use the referrer to redirect at the end of a form processing script, but it wont recognize the referrer. I read that it just wont work wi

[PHP-DB] mysql auto increment

2004-07-12 Thread Michael Gale
Hello, I know this is more of a mysql question then php with mysql but I can not find the answer. I have a primary key in a table the is setup and working with auto increment. Now I want to change it so it will start auto incrementing from 1000. So each entry will be: 1001, then 1002,

Re: [PHP-DB] mysql auto increment

2004-07-12 Thread John W. Holmes
Michael Gale wrote: I know this is more of a mysql question then php with > mysql but I can not find the answer. I have a primary > key in a table the is setup and working with auto increment. Now I want to change it so it will start auto incrementing > from 1000. So each entry will be: First of

Re: [PHP-DB] mysql auto increment

2004-07-12 Thread Jason Wong
On Tuesday 13 July 2004 07:19, Michael Gale wrote: > I know this is more of a mysql question then php with mysql but I can not > find the answer. www.mysql.com > search "auto increment" > http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html Keep reading and re-reading that page until you

Re: [PHP-DB] mysql auto increment

2004-07-12 Thread Ross Honniball
I just had a bit of a play with it and discovered you can do this: say your auto-increment index is named 'fred' for arguments sake. INSERT INTO table SET FRED = 1000 This will just create a record where the auto-index fred will equal 1000. Next auto-increment, NOT specifying a value for 'fred', wi