[SOLVED] putting mysql resluts in text box's

[kev wood]

i am trying to get the results from my mysql query and put them into text box'x so i can edit them.  i keep getting errors with the code though.

 

here is my code

 

$sql = ("SELECT * FROM $table WHERE id = $id");
$result = mysql_query($sql);

$row = mysql_fetch_array($result) or die(mysql_error());
echo '<form action="insert.php" method="post">'
echo 'Date: <input type="text" name="date" value="<?=$row['date'];?>" /><br /><br>'
echo 'Title:  <input type="text" name="title" value="<?=$row['title'];?>" /><br /><br />'
echo 'Article:<br /><textarea cols="50" rows="10" name="article" value="<?=$row['article'];?>" onkeyup="textLimit(this, 500);"></textarea><br />'
echo '<input type="submit" />'
echo '</form>'

 

the error i am getting is

 

Parse error: parse error, unexpected T_ECHO, expecting ',' or ';'

 

it says the error is on the line underneath the beginning of the form.  do i need to keep echoiing each line out?

 

any help with this would be great

[peranha]

After all your echo statements you need a ;

 

echo '<form action="insert.php" method="post">'

 

echo '<form action="insert.php" method="post">';

[beansandsausages]

how can you use this

<?=$row['date'];?>

 

in a php tag that is open ???

 

wouldnt you have to close the open tag first?

[kev wood]

that was my next question.  i have a column named date but when i use this in the code it is highlighted, how can i just get it to display the info held in the date column.

[revraz]

<? is short for opening PHP tags.  If you are in a PHP block, remove the <?

 

Use echo instead of =

[kev wood]

i have now put that section of code like this

 

value="<?=$row[\'date\'];?>"

 

but when the page is run the form is displaying but instead of putting the information into the box's i am getting

<?=$row[\'date\'];?>

inside of them instead of the text.

[kev wood]

i will try that now.  if you read this before the edit forgot i had changed

[beansandsausages]

try:

 

$sql = ("SELECT * FROM $table WHERE id = $id");
$result = mysql_query($sql);

$row = mysql_fetch_array($result) or die(mysql_error());
echo "<form action=\"insert.php\" method=\"post\">";
echo "Date: <input type=\"text\" name=\"date\" value=\"{$row['date']}\" /><br /><br>";
echo "Title:  <input type=\"text\" name=\"title\" value=\"{$row['title']}\" /><br /><br />";
echo "Article:<br /><textarea cols=\"50\" rows=\"10\" name=\"article\" value=\"{$row['article']}\" onkeyup=\"textLimit(this, 500)\"</textarea><br />";
echo "<input type=\"submit\" />";
echo "</form>";

[revraz]

echo "Date: <input type='text' name='date' value=\"$row['date']\" /><br /><br />";

 

[R4nk3d]

echo "Date: <input type='text' name='date' value=\"$row['date']\" /><br /><br />";

 

this is the one that will work, and just in case it doesnt, make it:

echo "Date: <input type='text' name='date' value=\"$row[date]\" /><br /><br />";

without the 's around date.

[kev wood]

no i am getting this error now

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' 

 

on the article line

[revraz]

Burn's should also work just fine.

 

And using ' is fine.

[revraz]

You probably forgot a ending ; on the line before.

[kev wood]

burns is working now.  why i got errors from it before i dont.  i copied and pasted it in and got errors just done it again and there are no errors now.  just not putting the text into the text box

[R4nk3d]

Burn's should also work just fine.

 

And using ' is fine.

ive gotten errors from it before and it just didnt work sometimes so i didnt know. just trying to help.

[kev wood]

sorted this line is wrong

 

echo "Article:<br /><textarea cols=\"50\" rows=\"10\" name=\"article\" value=\"{$row['article']}\" onkeyup=\"textLimit(this, 500)\"</textarea><br />";

 

it should be

 

echo "Article:<br /><textarea cols=\"50\" rows=\"10\" name=\"article\" onkeyup=\"textLimit(this, 500)\">{$row['article']}</textarea><br />";

[revraz]

It was probably something else causing the error.

 

 

 

Burn's should also work just fine.

 

And using ' is fine.

ive gotten errors from it before and it just didnt work sometimes so i didnt know. just trying to help.

[beansandsausages]

sorted this line is wrong

 

echo "Article:<br /><textarea cols=\"50\" rows=\"10\" name=\"article\" value=\"{$row['article']}\" onkeyup=\"textLimit(this, 500)\"</textarea><br />";

 

it should be

 

echo "Article:<br /><textarea cols=\"50\" rows=\"10\" name=\"article\" onkeyup=\"textLimit(this, 500)\">{$row['article']}</textarea><br />";

 

so it is

[R4nk3d]

dont forget to use the topic solved button

[kev wood]

i will now thanks for all your help on this.