RE: [PHP] Inserting Processed Data from One Table 2 Another!

fetch_assoc($result)) { > $code = generateRandomString(8); > mysql_query("INSERT INTO authentication (id, pass) > VALUES > ($myrow[clientid], '".$code."'"); > }; > > Hope this helped you ! > > Greetz, > Wouter > &g

Re: [PHP] Inserting Processed Data from One Table 2 Another!

You might want to consider a slightly different approach - that being to use your php code to generate a delimited file of your data and use either mysqlimport from the command line if you can, or the LOAD DATA INFILE sql statement to load the file into your database. That's going to be a lot fast

RE: [PHP] Inserting Processed Data from One Table 2 Another!

erzonden: woensdag 24 juli 2002 9:02 Aan: [EMAIL PROTECTED] Onderwerp: [PHP] Inserting Processed Data from One Table 2 Another! Ok i have simple issue, i'm stuck at one point. I have a table "Clientdetails" which contains ClientID. I have created another table "Authenticat

[PHP] Inserting Processed Data from One Table 2 Another!

Ok i have simple issue, i'm stuck at one point. I have a table "Clientdetails" which contains ClientID. I have created another table "Authentication" with 2 fields, "ClientID" and "Password". I want to pick up the ClientID from table "Clientdetails" and insert "ClientID" and a Password i have ge