T_VARIABLE Error

[ygrouk]

Hi Guys

Please help, i have tried to code this and keep getting


Parse error: parse error, unexpected T_VARIABLE, expecting ',' or ';' in /home/httpd/vhosts/xxxxx.com/httpdocs/php/users/reg.php on line 160


it happens with this code

function addNewUser($title, $f_name, $surname, $address1, $address2, $towncity, $countystate, $zippostcode, $country, $telnum, $mobnum, $faxnum, $email, $username, $password){
   global $conn
   $q = "INSERT INTO users VALUES('$title', '$f_name', '$surname', '$address1', '$address2', '$towncity', '$countystate', '$zippostcode', '$country', '$telnum', '$mobnum', '$faxnum', '$email', '$username')";
   $q1 = "INSERT INTO user_id VALUES('$username', '$password', '$email', '0', '0', '$f_name')";
   return mysql_query($q,$conn);
   return mysql_query($q1,$conn);
} 

please help,....

pete

[Desinc]

global $conn

Does that need an ';' affter it? I'm not sure.

[ygrouk]

Thanks Desinc

Thanks Mate

All Working OK Now

Pete

[Celtboy]

for the record, you can't return two values like that...as soon as it hits the first return statement, it exits the function. to return two values, return them as an array

function addNewUser($title, $f_name, $surname, $address1, $address2, $towncity, $countystate, $zippostcode, $country, $telnum, $mobnum, $faxnum, $email, $username, $password){
   global $conn
   $q = "INSERT INTO users VALUES('$title', '$f_name', '$surname', '$address1', '$address2', '$towncity', '$countystate', '$zippostcode', '$country', '$telnum', '$mobnum', '$faxnum', '$email', '$username')";
   $q1 = "INSERT INTO user_id VALUES('$username', '$password', '$email', '0', '0', '$f_name')";
  $res1= mysql_query($q,$conn);
   $res2= mysql_query($q1,$conn);
return array($res1,$res2);
}