Ad:

PHP Discussion Thread
Unsolved
Views: 36

Jul 30th, 2010

setting the value in my

Expand Post »

can some tell me what's wrong i tried putting the $date in my textfield from my MySQL. can someone pls correct my code

thanks

PHP Syntax (Toggle Plain Text)
<?php
$username="root";
$password="";
$database="dbdate";
 
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
 
$query = "SELECT *
FROM `cdate`
WHERE 1
LIMIT 0 , 30";
$result = mysql_query($query) or die(mysql_error());
 
while($row = mysql_fetch_array($result)) {
	echo $row['date'];
	}
?>
 
<input name = "date"  value="<? echo $row['date']; ?>" type="text" />
<?php
$username="root";
$password="";
$database="dbdate";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");

$query = "SELECT *
FROM `cdate`
WHERE 1
LIMIT 0 , 30";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {
	echo $row['date'];
	}
?>

<input name = "date"  value="<? echo $row['date']; ?>" type="text" />

Similar Threads

newbie: need help setting up my network, router + firewall problems in Networking
help setting up web server in Linux Servers and Apache
Setting up a 2nd hard drive in Windows NT / 2000 / XP
setting up a new network in Networking
Video setting question in Monitors, Displays and Video Cards

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 30th, 2010

Re: setting the value in my

echo your query. copy and past in mysql db u will found error

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

Permalink

Jul 30th, 2010

Re: setting the value in my

I am not sure what actually you wanna do but hope fully this may help,

1st problem: localhost is not in "" (quots)

that should be like this
mysql_connect("localhost",$username,$password);

2nd:
<input name = "date" value="<? echo $row['date']; ?>" type="text" /> is out side of loop so that $row have no value in it
see this, this will print multiple(according to the database records)input fields with date values in it

PHP Syntax (Toggle Plain Text)
<?php
$username="root";
$password="";
$database="dbdate";
 
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die("Unable to select database");
 
$query = "SELECT *
FROM `cdate`
WHERE 1
LIMIT 0 , 30";
$result = mysql_query($query) or die(mysql_error());
 
while($row = mysql_fetch_array($result)) {
	//echo $row['date'];
	echo "<input name = \"date\"  value=\"" . $row['date'] . "\" type=\"text\" /> <br /> <br />";
}
?>
<?php
$username="root";
$password="";
$database="dbdate";

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die("Unable to select database");

$query = "SELECT *
FROM `cdate`
WHERE 1
LIMIT 0 , 30";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {
	//echo $row['date'];
	echo "<input name = \"date\"  value=\"" . $row['date'] . "\" type=\"text\" /> <br /> <br />";
}
?>

PHP Syntax (Toggle Plain Text)
<?php
$username="root";
$password="";
$database="dbdate";
 
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die("Unable to select database");
 
$query = "SELECT *
FROM `cdate`
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" />
<?php
$username="root";
$password="";
$database="dbdate";

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die("Unable to select database");

$query = "SELECT *
FROM `cdate`
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" />

Last edited by katarey; Jul 30th, 2010 at 8:01 am.

katarey

Reputation Points: 39

Solved Threads: 23

Junior Poster

Offline

167 posts
since Jul 2005

Permalink

Jul 30th, 2010

Re: setting the value in my

here a good link for reference

http://www.anyexample.com/programmin...a_fetching.xml

katarey

Reputation Points: 39

Solved Threads: 23

Junior Poster

Offline

167 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: php/java integration

Next Thread in PHP Forum Timeline: PHP Code to access SQL SERVER 2008 tables

DaniWeb Message

Cancel Changes

User Name
Password