[PHP] Strange problem... From: Daniel Alsén (d <email protected>)
Date: 11/30/01

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 #
# d <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: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>