Email and mySQL

• ********

  Morning all,

  I'm trying to work out the best way of importing email address that may be from a CSV file or TXT file (can be either) but also add a unique ID on the fly to them... e.g. So I can then send out a link with their address in it, with the unique ID to it, so that it is verified that they are infact the user, and can't just add any email address to the link?

  Any good sites for things like this rather than me trying to write it myself from the ground up?

  ********

  Flag

• acescence0

  http://pastebin.se/47219

  this will loop thru and insert the emails with row number, or you can change $row to generate a random number, use mysql's unique and auto_increment, or make it an md5 hash of the email + row number, etc..

  acescence 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel