add multiple records as a result from an if statement
Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the user completes two sections, two records will be added into the database instead of one. and if they complete one section, only one record will be added. can any one help me? Thanks Kaan. MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert record x 2
Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the user completes two sections, two records will be added into the database instead of one. and if they complete one section, only one record will be added. can any one help me? Thanks Kaan. MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: MYSQL Auto-Increment Field
Hi, I have set up a table with 3 fields. But I have forgetten to add a primary key (I'm not sure if its a primary key I want, I just want a auto-Increamentig field at the begging of the table. can anyone tell me how I do this. Cheers sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANTs and %
Thanks Dan And Okan for replying to my email but I have tried what you have said but I still get the same problem. GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' IDENTIFIED BY '123'' at line 1 GRANT ALL ON newstesting.* clients@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near 'clients@'%' IDENTIFIED BY '123'' at line 1 any ideas what is going on? MySQL is server version: 3.23.36 Thanks, Kaan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php