RE: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Willie G
Miles, I never use auto increment. Not because of gaps, but in case I need to reload the table. They do have meaning if they are foreign keys to another table. - Larry -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 16, 2003 1:14 PM To: Philli

RE: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Willie G
Phillip, You will have to change your code, so the primary key is not an auto incremented value. If you don't, the auto increment will over-ride the 'get next' function. Here is what I use in my code. You just need to change it for your table. //- GetNextKey -// function getnextkey(){

RE: [PHP] Re: SQL Query

2003-02-15 Thread Willie G
ruary 15, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: SQL Query The result recived from that query is this ID SubID Interest Valid Edit Delete 4 3 Star Craft 1 But I want a Query that retrives "Star Craft", "Strategi", "Spel" and &qu

RE: [PHP] Re: SQL Query

2003-02-15 Thread Willie G
Zydox, Please define 'sub-interest'. I've looked at what Uttam gave you, and it looks correct, assuming you want want it limited to the same user. If you result should be 'all with Interest = X and Valid = Y", just remove the userid from the second query. SELECT InterestsList.ID, InterestsList.

RE: [PHP] SESSION variable to pass login ID

2003-01-12 Thread Willie G
, > > I do have a session_start() in both files, but it does not seem to help. > > - Larry > > -Original Message- > From: Tom Rogers [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 12, 2003 11:36 AM > To: Willie G > Cc: [EMAIL PROTECTED] > Subject: Re: [P

RE: [PHP] SESSION variable to pass login ID

2003-01-12 Thread Willie G
Tom, I do have a session_start() in both files, but it does not seem to help. - Larry -Original Message- From: Tom Rogers [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 11:36 AM To: Willie G Cc: [EMAIL PROTECTED] Subject: Re: [PHP] SESSION variable to pass login ID Hi

[PHP] SESSION variable to pass login ID

2003-01-12 Thread Willie G
Hi, I have been trying to solve the problem of using session variables, but I have not had any luck. What I want to do is simple, I want to set my userid and password in a login screen and use it later (in another php form) to log into the database. In my login PHP file I have the following: if