SQL Statement Error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Piera
Jason's GF
Posts: 10
Joined: Fri Apr 19, 2002 9:30 am
Location: Montreal
Contact:

SQL Statement Error

Post by Piera »

I can't seem to find what is wrong with this sql string

Code: Select all

$sql = "INSERT into users
			first_name,last_name,address,city,
			state_prov_id,country_id,zipcode,
			user_name,email_address,casino_id VALUES
			('".$_POSTї'first_name']."',
			 '".$_POSTї'last_name']."',
			 '".$_POSTї'address']."',
			 '".$_POSTї'city']."',
			 '".$_POSTї'state_prov_id']."',
			 '".$_POSTї'country_id']."',
			 '".$_POSTї'zipcode']."',
			 '".$_POSTї'user_name']."',
			 '".$_POSTї'email_address']."',
			 '".$_POSTї'casino_id']."')";
$insert_info = mysql_query($sql);
Piera
Jason's GF
Posts: 10
Joined: Fri Apr 19, 2002 9:30 am
Location: Montreal
Contact:

Post by Piera »

Nevermind stoooopid me forgot parenthesis!
Thanks to my cutie patootie for his help
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Post by jason »

Don't worry, I corrected this. The words "Oh <span style='color:blue' title='I&#39;m naughty, are you naughty?'>smurf</span>!" came out of her mouth when I told her the error.

For those curious, missing ( and ).
qads
DevNet Resident
Posts: 1199
Joined: Tue Apr 23, 2002 10:02 am
Location: Brisbane

Post by qads »

hmm.....are all of you php mad?
:P jason is, his girl friend is, what bout your rest of familes? :twisted:
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Post by jason »

God no, our families are atypical "A good, your here, I have a problem with my computer...and was hoping you could fix it." types.

Of course, Piera and I both shop at ThinkGeek (she has the "No, I will not fix your computer" shirt to boot!, I just have the SQL one )
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

if it would be the family only ;)
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Cutie ?

Post by BDKR »

Jason,

Which of those cutie patooties that comes up as your avatar is your girlfiriend? :o

Don't worry, just being :twisted:

Cheers,
BDKR (TRC)
Post Reply