Variable is dropping string data

[Anon]

I am trying to pass two variables to another page by appending them to the query string:

while ($myrow=mysql_fetch_array($result))
{
printf("<tr bgcolor=%s>
<td><a href=bandpage.html?bandid=$myrow[0]&name=$myrow[1]>%s</a></td><td>%s</td>... etc.

myrow[0] is fine b/c its a number, the band id. but if the band name has spaces in it, I only get the first word

is there a function for this? I tried "&name= print ($myrow[1])", but its tricky b/c its already nested inside a printf statement

[Anon]

just use echo and it should be fine. I've never had a problem with echo before. it's actually a bit faster than printf too and I think it's much cleaner. Try this.

<tr bgcolor=%s>
<td><a href=bandpage.html?bandid=<?php echo $myrow[0] ?>&name=<?php echo $myrow[1]; ?>>
%s
</a></td>
<td>%s</td>
</tr>

Also, you might wanna use the object mysql functions since you can go $row->id and $row->name instead of using array indices. It's much easier to read and you'll never have to change the code unless you change the attribute name in the table.

[Anon]

Found the problem, and it was not passing variables. The variables were passing fine. It was not until I viewed source to see that the problem was - the text of my alt tags were not in quotes (img alt=\"$whatever\")

d'oh!