Display date in a text box

I'm just starting in PHP so this may seem obvious, please bear with me.

I have an input form for users and I want to give the date input box the value of today's date.

This is what I have so far for the first page:

<?php

$db = mysql_connect("localhost", "webuser@localhost");
mysql_select_db("mydb",$db);

$result = mysql_query ("SELECT curdate()");

print "Date = ";
print "$result";

?>

This returns a value of 2.

Then I have a page which writes this date input box:

print ("<li> Date:</li>");
print ("<input type='Text' name='Title' value='$result'>");
print ("<br>");


This returns doesn't even insert the 2 value. Perhaps I don't need 2 php pages to do this? Any ideas?

Cheers in advance.

You should do both things in same page then only you get desired result.


This returns a value of 2.


bcoz your result has fetched some records.using mysql_fetch_array() function you will have to get that value...

try the following

#########-------

test.php3

<?php

$db = mysql_connect("localhost", "webuser@localhost");
mysql_select_db("mydb",$db);

$result = mysql_query ("SELECT curdate()");

$row=$mysql_fetch_array($result);

echo "Date : <input type="text" value="$row[0]">n";
?>

Good Luck!!!



------------------
SR -
webshiju.com

"The fear of the LORD is the beginning of knowledge..."

Just worked it out using someone else's reply. Hope this might be of use to someone else:

<?

$Date = date("Y m d");

print ("<input type='Text' name='Date_Written' value='$Date'>");

?>

Simple really...