Here is my latest code:
$query = "INSERT INTO Accounts SET username='$username',
password='$password', email='$email'";
$results = mysql_query($query);
//return mysql_insert_id();
return $results;
However I get a return of FALSE and nothing gets inserted into the database.
Any ideas?
I really appreciate the help..
Vince
----- Original Message -----
From: [EMAIL PROTECTED] on behalf of D.N.
Sent: Tue, 5/1/2007 11:57am
To: Open Source Flash Mailing List
Subject: Re: [osflash] AMFPHP INserting into database, Please HLP
ehr... I mean:
$query = "INSERT INTO Accounts SET
username='$username', password='$password', email='$email'"
forgot the SET, my bad!
Daan
----- Original Message -----
From:
D.N.
To: Open Source Flash Mailing List
Sent: Tuesday, May 01, 2007 5:06 PM
Subject: Re: [osflash] AMFPHP INserting
into database, Please HLP
how about just:
$query = "INSERT INTO Accounts
username='$username', password='$password', email='$email'"
hope this helps,
Daan
----- Original Message -----
From:
Cordaro, Vince
To: [email protected]
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
[email protected]
http://osflash.org/mailman/listinfo/osflash_osflash.org
_______________________________________________
osflash mailing
list
[email protected]
http://osflash.org/mailman/listinfo/osflash_osflash.org
_______________________________________________
osflash mailing list
[email protected]
http://osflash.org/mailman/listinfo/osflash_osflash.org
