[PHP-DB] AUTO_INCREMENT
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)
thankx for the reply's on my mail Joris Kluivers
[PHP-DB] javascript variables
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!
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
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
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
thanks for the REPLACE INTO query joris