Page 1 of 1

SQL Statement Error

Posted: Wed Jun 19, 2002 1:20 pm
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);

Posted: Wed Jun 19, 2002 1:36 pm
by Piera
Nevermind stoooopid me forgot parenthesis!
Thanks to my cutie patootie for his help

Posted: Wed Jun 19, 2002 1:37 pm
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 ).

Posted: Wed Jun 19, 2002 4:23 pm
by qads
hmm.....are all of you php mad?
:P jason is, his girl friend is, what bout your rest of familes? :twisted:

Posted: Wed Jun 19, 2002 4:28 pm
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 )

Posted: Wed Jun 19, 2002 4:40 pm
by volka
if it would be the family only ;)

Cutie ?

Posted: Thu Jun 20, 2002 10:12 am
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)