chaLLenge+4

Anon

My band database uses the following code to retrieve rows containing band name (linked to url), genre, and description:

while ($myrow=mysql_fetch_array($result)){
printf("<tr>
<td><a href=\"$myrow[3]\">%s</a></td>

<td>%s</td>
<td>%s</td>
</tr>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3]);
}

How can I pass these $myrow[] variables to another php page where I will format the contents of only one row on a page? In other words, I want the band name linked to something like "bandpage.php", rather than the url from the database ($myrow[3]). I have tried hidden forms and HTTP_POST_VARS, but cant get any results.

Thanks for the help.

Anon

Sessions maybe?

Anon

I'm more worried about passing the elements of the array than I am about preserving state - some of the band descriptions are very long (but there's no limit to the amount of data in the element of an array, right?)

hawleyj

Perhaps pass the key in a query string to the page bandpage.php and use it to query the database and retrieve the appropriate info on the new page:

while ($myrow=mysql_fetch_array($result)){
printf("<tr>
<td><a href=\"bandpage.php?$myrow[3]\">%s</a></td>
<td>%s</td>
<td>%s</td>
</tr>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3]);
}

When you get to the next page, use the value of $myrow[3] to query and retrieve the info. Note that you should use the key field for the row for this, a field that is absolutely unique for that record (an ID number is best, there may be different bands with the same name). That way there is no doubt you have the right band.

HTH,

Jim Hawley