Strange problem...
| From: | Daniel Alsén | Date: | Fri, 30 Nov 2001 22:43:42 +0000 |
| Subject: | Strange problem... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76267@lists.php.net to get a copy of this message | ||
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@mindbash.com | +46 704 86 14 92 #
# ICQ: 63006462 | +46 8 694 82 22 #
# PGP: http://www.mindbash.com/pgp/ #