Show date from field

[DaveSawers]

What do you mean by "PHP submission"?

[edhan]

I have created a database Table with 2 fields - date1 and person.
Field in column for date1 is 19790103, 19710304, 20010923, etc. And the field for Person in column is Peter, Andrew, William, etc corresponding to their date of birth.

What I want to do next will be extracting the date to show in HTML as: Birthdate: 01 03, 1979 for Peter when I submit this in the form with that date of birth. This form in php submission using:

<SELECT NAME="day1"> with option 1 to 31
<SELECT NAME="month1"> with option 1 to 12
<SELECT NAME="year1"> with option 1950 to 2011

Hope this explanation is clear. I am just starting to write this and encountering the problem of not able to echo the birthdate when selecting the birth date upon submission.

PHP submission means I have a form named as check.php with the form created to select the birthdate and submit online to show the result.

[ramorius]

OK - maybe it's just me, but are you SELECTing the $date1 from the database and then not able to get the $birthdate from that? If so, the reason might be that $year1, $month1 and $day1 are not assigned any values just because you got $date1 and reconstructed how it was created.

You probably need something like this

	$db = @mysql_connect('localhost', 'dbuser', 'dbpass');
	@mysql_select_db('dbname', $db);

	$result = mysql_query("SELECT * FROM  `match` WHERE `person` = '$person'", $db);
	$row = mysql_fetch_assoc($result);

        $year1 = substr($row[date1],0,4);
        $month1 = substr($row[date1],4,2);
        $day1 = substr($row[date1],6,2);

        $birthdate1 = " (Birthdate: ".$month1." ".$day1.", ".$year1.") ";

I hope this helps,
Rob

[edhan]

OK - maybe it's just me, but are you SELECTing the $date1 from the database and then not able to get the $birthdate from that? If so, the reason might be that $year1, $month1 and $day1 are not assigned any values just because you got $date1 and reconstructed how it was created.

You probably need something like this

	$db = @mysql_connect('localhost', 'dbuser', 'dbpass');
	@mysql_select_db('dbname', $db);

	$result = mysql_query("SELECT * FROM  `match` WHERE `person` = '$person'", $db);
	$row = mysql_fetch_assoc($result);

        $year1 = substr($row[date1],0,4);
        $month1 = substr($row[date1],4,2);
        $day1 = substr($row[date1],6,2);

        $birthdate1 = " (Birthdate: ".$month1." ".$day1.", ".$year1.") ";

I hope this helps,
Rob

Yes. Thank you very much. It is resolved!