Help requested: MySQL fields cut off

[dejansen]

I can't remember the solution to the minor problem I'm having...

I am querying a MySQL db and putting the results in text boxes so I can edit the fields and update. Here's an example:

$query="SELECT id, title, artist, label FROM jazz";
$result=mysql_query($query);

do {

$idStr=id.$index;
$titleStr=title.$index;
$artistStr=artist.$index;
$labelStr=label.$index;

printf("<tr><td><input type=hidden name=%s value=%s>
	<input type=text name=%s value=%s></td>
	<td><input type=text name=%s value=%s></td>
	<td><input type=text name=%s value=%s></td>
	</tr>\n",
	$idStr, $myrow["id"],
	$titleStr, $myrow["title"],
	$artistStr, $myrow["artist"],
	$labelStr, $myrow["label"]);

$index++;
$index_count++;
} while ($myrow=mysql_fetch_array($result));

The problem is that anything after the first space for each field retrieved is cut. So if the title is "Blue Train", only "Blue" shows up in the textbox. Can someone remind me how to make sure the entire field is placed in the textbox?

Thank you!

[[deleted]]

Use quotes around the values in the parameters of your HTML tags.

[dejansen]

Thanks. That was part of the problem. The other was making sure any single or double quotes in the field were dealt with properly. htmlentities() was the solution.