Leeftijd uitrekenen vanuit MYSQL en van verkorte tekens naar volledige tekst
`id` int(4) NOT NULL AUTO_INCREMENT,
`username` varchar(65) NOT NULL DEFAULT '',
`password` varchar(65) NOT NULL DEFAULT '',
`Age` text NOT NULL,
`mv` int(3) NOT NULL,
`credits` varchar(10) NOT NULL DEFAULT '60',
`email` varchar(225) NOT NULL,
PRIMARY KEY (`id`)
Weet je ook hoe ik de 1/2 m/v kan laten uitprinten als Man / Vrouw, want daar ging eigenlijk het gehele forum post over :P
Code (php)
1
2
3
2
3
<?php
($row['mv'] == 1 ? 'Man' : 'Vrouw')
?>
($row['mv'] == 1 ? 'Man' : 'Vrouw')
?>
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
SELECT (CASE
WHEN MONTH(NOW()) > MONTH(birthdate) THEN
YEAR(NOW()) - YEAR(birthdate) - 1
WHEN MONTH(NOW()) = MONTH(birthdate) THEN
IF(DAYOFMONTH(NOW()) <= DAYOFMONTH(birthdate),
YEAR(NOW()) - YEAR(birthdate),
YEAR(NOW()) - YEAR(birthdate) - 1)
ELSE
YEAR(NOW()) - YEAR(birthdate) END) AS age,
(CASE mv WHEN 'm' THEN 'man' WHEN 'v' THEN 'vrouw' ELSE 'weet niet' END) AS sex
WHEN MONTH(NOW()) > MONTH(birthdate) THEN
YEAR(NOW()) - YEAR(birthdate) - 1
WHEN MONTH(NOW()) = MONTH(birthdate) THEN
IF(DAYOFMONTH(NOW()) <= DAYOFMONTH(birthdate),
YEAR(NOW()) - YEAR(birthdate),
YEAR(NOW()) - YEAR(birthdate) - 1)
ELSE
YEAR(NOW()) - YEAR(birthdate) END) AS age,
(CASE mv WHEN 'm' THEN 'man' WHEN 'v' THEN 'vrouw' ELSE 'weet niet' END) AS sex
Gewijzigd op 10/04/2012 15:54:59 door Ger van Steenderen
