help with SELECT - not recognizing spaces

[__greg]

I'm trying to select rows from my table and have them show up in an input field so they can be updated. It's kind of working, but whenever it selects something, it'll only display the first word in the box... up until a space, then it wont show any more.

anyone know how i can get it to show everything (including spaces)?

$result = mysql_query("SELECT * FROM evr_bands WHERE band_id='" . $HTTP_POST_VARS[bandselect] . "'");
while($row = mysql_fetch_array($result)) {
echo "<tr>
	<td align=right><b>Band:</b></td>
	<td colspan=4><input name=band type=text size=50 class=box value=".$row["band"]."></td>
</tr>";
	}

Thanks so much!

[stolzyboy]

change this

<input name=band type=text size=50 class=box value=".$row["band"].">

to this

<input name=band type=text size=50 class=box value=\"".$row["band"].\"">

[__greg]

oh yeah. hah. that would make sense! thank you very much!