[RESOLVED] Only the first word is showing?

[Pineapple]

Hi all PHPBuilders,

I'm trying to get information from my database. But the fields are only showing the first word?

In the database the field is "hello t-shirt", and the field is only showing "hello"...

  $result = mysql_query("SELECT * FROM products WHERE id='".mysql_real_escape_string($_GET["id"])."'");
  $row = mysql_fetch_array($result);

  echo "<form action=\"gemprodukt.php\" method=\"post\">";
  echo "<input type='hidden' name='id' value='".$_GET["id"]."' /><br /><br />";
  echo "<b>ID: </b>".$_GET["id"]."<br /><br />";
  echo "<input type=\"text\" size=\"80\" name=\"title\" value=".$row["title"]." /><br /><br />";
  echo "<textarea name=\"body\" cols=\"80\" rows=\"10\" value=".$row["body"]."></textarea><br /><br />";
  echo "<input type=\"text\" size=\"80\" name=\"price\" value=".$row["price"]." /><br /><br />";
  echo "<input type=\"text\" size=\"80\" name=\"image\" value=".$row["image"]." /><br /><br /><br />";
  echo "<input type=\"submit\" value=\"Update product\" /><br /><br /><br />";
  echo "</form>";

It's really strange (for me)... Hope some of you guys could help me out :-)

[bradgrafelman]

Your problem is caused by invalid HTML. All HTML attributes' values must be surrounded with quotes.

[jeepin81]

I'm not really sure what you're trying to accomplish or how your DB is setup but you'll have to loop through your db to get your results:

$result = mysql_query("SELECT * FROM products WHERE id='".mysql_real_escape_string($_GET["id"])."'"); 

//loop through the table to retrieve data
while($row = mysql_fetch_array($result)){
$title = $row['title'];
$body = $row['body'];
$price = $row['price'];
$image = $row['image'];
}

   echo "<form action=\"gemprodukt.php\" method=\"".$_SERVER['PHP_SELF']."\">"; 
  echo "<input type='hidden' name='id' value='".$_GET["id"]."' /><br /><br />"; 
  echo "<b>ID: </b>".$_GET["id"]."<br /><br />"; 
  echo "<input type=\"text\" size=\"80\" name=\"title\" value=\"".$title."\" /><br /><br />"; 
  echo "<textarea name=\"body\" cols=\"80\" rows=\"10\" >".$body."</textarea><br /><br />"; 
  echo "<input type=\"text\" size=\"80\" name=\"price\" value=\"".$price."\" /><br /><br />"; 
  echo "<input type=\"text\" size=\"80\" name=\"image\" value=\"".$image."\" /><br /><br /><br />"; 
  echo "<input type=\"submit\" value=\"Update product\" /><br /><br /><br />"; 
  echo "</form>";  

Also, you should do some type of error checking.

Hope this helps.
j

edit: saw b post

[bradgrafelman]

@: This code:

//loop through the table to retrieve data 
while($row = mysql_fetch_array($result)){ 
$title = $row['title']; 
$body = $row['body']; 
$price = $row['price']; 
$image = $row['image']; 
} 

Doesn't make much sense, since you're overwriting the values of those variables on each iteration of the loop without doing anything with them. In other words, you're only going to be able to work with the last result in the result set, so you might as well skip to that row and only retrieve the data once.

[jeepin81]

good point.

[Pineapple]

I got it to work thanks to the code jeepin81 posted...

Thank you all so much for your help. Love this community :-)