[osflash] AMFPHP INserting into database, Please HLP

[D.N.]

how about just:

$query = "INSERT INTO Accounts username='$username', password='$password', email='$email'"

hope this helps,
Daan
  ----- Original Message ----- 
  From: Cordaro, Vince 
  To: osflash at osflash.org 
  Sent: Tuesday, May 01, 2007 4:27 PM
  Subject: [osflash] AMFPHP INserting into database, Please HLP


  I am having trouble getting my insert into my mysql database to work. 

  My database has a table called Accounts and I 4 fields, 

  ID, primary Key, Int
  username, varchar
  password, varchar
  email, varchar

  I have tried all kinds of different things.  I just can't seem to find a tutorial on how to write to the database.

  This is my actually PHP insertAccount function:

      /**
          mysql_query("INSERT INTO Accounts(NULL,'".addslashes($username)."',
           '".addslashes($password)."',
           '".addslashes($email)."')");
           **/
           $sql = sprintf("INSERT INTO Accounts(NULL,%s,%s,%s)",$username,$password,$email);
          
           $query = mysql_query($sql);
          
           //return mysql_insert_id();
           return $query;




  Vince



------------------------------------------------------------------------------


  _______________________________________________
  osflash mailing list
  osflash at osflash.org
  http://osflash.org/mailman/listinfo/osflash_osflash.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://osflash.org/pipermail/osflash_osflash.org/attachments/20070501/5d884805/attachment.htm