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

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

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

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