Hola Daniel:

Te escribo en castellano ya que veo que el inglés no es tu idioma natural.

Creo que el error se produce al concatenar las variables, acordate que para
indicar que las variables con cadenas tenés que encerrarlas entre "", yo lo
definiría así:

$user_birthdate = "$birth_year-$birth_month-$birth_day"; // 1982-12-08

Saludos

Edgardo

"Daniel alsén" <[EMAIL PROTECTED]> escribió en el mensaje
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> i have a strange problem.
>
> I get a users birthdate with three dropdown menus (year, month and day of
> month). I get these values into one string with:
>
> $user_birthdate = $birth_year . $birth_month . $birth_day;
>
> If i echo $user_birthdate after this it is correct (yyyymmdd). But when i
> insert the value of $user_birthdate into MySql it gets the value
'8388607'.
> It doesn´t matter what value $user_birthdate had originally - it always
> inserts as 8388607.
>
> Any ideas???
>
>
>
> The db question looks like this btw:
>
> $query = "INSERT INTO users ";
>
> $query .= "(user_name, user_birthdate, user_city, user_mail, user_icq,
> user_msn, user_www, user_login, user_password) ";
>
> $query .= " values('$user_name', '$user_birthdate', '$user_city',
> '$user_mail', '$user_icq', '$user_msn', '$user_www', '$user_login',
> '$user_password')";
>
>
> Regards
> # Daniel Alsén    | www.mindbash.com #
> # [EMAIL PROTECTED]  | +46 704 86 14 92 #
> # ICQ: 63006462   | +46 8 694 82 22  #
> # PGP: http://www.mindbash.com/pgp/  #
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to