[PHP-DB] AUTO_INCREMENT

[Joris Kluivers]

hi,

i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message 
text, username varchar(100), UNIQUE id (id);

I insert records with:
INSERT INTO chatmessages (message, username) VALUES ('$message', '$username')

this works fine (for a while), i can insert messages and retreive them with php.
But after some time i get the error:
ERROR 1062: Duplicate entry '127' for key 1
but how can this be because i've set it to AUTO_INCREMENT.

can someone help me?
thanks in advance

Joris Kluivers

[PHP-DB] thankx (AUTO_INCREMENT)

[Joris Kluivers]

thankx for the reply's on my mail

Joris Kluivers

[PHP-DB] javascript variables

[Joris Kluivers]

Hi 
yes these variables are available in php
referer = $HTTP_REFERER;
window.location = $HTTP_HOST . $REQUEST_URI;

Joris

Re: [PHP-DB] AOL and Cookies (sessions) HELP!

[Joris Kluivers]

off topic,

set a cookie at one page, redirect to the other, 
found a cookie: ->  redirect to the login
no cookie: -> redirect to the instructions page

Joris

- Original Message - 
From: "Adv. Systems Design" <[EMAIL PROTECTED]>
To: <>
Sent: Sunday, June 24, 2001 9:21 PM
Subject: [PHP-DB] AOL and Cookies (sessions) HELP!


> I have a login procedure using php4 sessions that
> craps out when people try to login using the AOL
> browser...basically the AOL browser just ignores the
> cookie (due to a proxy server blocking it I think) and
> the user can't log in and they don't get any feedback
> about it either...they are just presented with the
> login screen...again!!!
> 
> Is there a way to detect when the cookie was IGNORED
> and present the user with an alternate screen giving
> them info on the failure and steps to correct it? (The
> only way I know of correcting this is to tell the
> users to MINIMIZE the AOL browser and LAUNCH
> IExplorer)
> 
> Luis
> 
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] phpMyAdmin: delete table

[Joris Kluivers]

Hi

I think you don't have php running on your machine. you need php in order to
use php myadmin.

Joris
- Original Message -
From: "thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 3:30 PM
Subject: [PHP-DB] phpMyAdmin: delete table


> Hi, I'm new to phpMyAdmin but they told me to use this programm to delete
a
> table from my mysql database.
> I've configured the file and when i try to run phpMyAdmin i can see my
> database on the left frame, however the right frame doesn't show up at
all.
> (instead there's a download dialog box opening all the time). When i
> download the file and open it in notepad i get an unreadable set of
> characters
>
> what should i do to delete that table??
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Insert Update

[Joris Kluivers]

is there a mysql query that inserts into a database, but if the item already exists it 
does not insert but updates?

Joris

[PHP-DB] Insert Update

[Joris Kluivers]

thanks for the REPLACE INTO query

joris