<?php
$username="root";
$password="";
$database="kuhadate";
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query = "SELECT *
FROM `ddate`
WHERE 1
LIMIT 0 , 30";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result)
?>
<input name = "date" value="<?php echo $row['date']; ?>" type="text" />
[B]<input name = "month" value="" type="text" />
<input name = "day" value="" type="text" />
<input name = "year" value="" type="text" />[/B]
so I'm currently being able to retrieve one and the only date in my database as soon as my page loads (testing stage, still) and thank you to one of the experts here that was able to help me. And now, I want to place the date to separate fields. To one of my textbox it's getting a value of 2010-07-29, now as you can see above the bold texts, I want also for it to be able to retrieve date but now [(07 = July)][(29 = the day)][(2010 = year)] thank you for the help experts.