[blitzfx]

Hi,

I'm not sure how to word this but I'll start off with some code I have:

$result = mysql_query("SELECT * FROM Music") or die(mysql_error());  
while($row = mysql_fetch_array($result))
{
echo htmlentities($row['Title']);
echo htmlentities($row['parta']);
echo htmlentities($row['partb']);
echo htmlentities($row['partc']);
echo "<p>";
}

This outputs to a html page.
I have another php script which accepts multiple variables

I want to be able to generate a (radio)/submit button at the end of each iteration of the while loop that will send the data from $row['parta'], $row['partb'] etc. to my other php script using post (get is too small).

I was thinking that maybe I could generate forms with 4 un-editable textareas with $row['parta'] etc displayed in it or something and submit using post but then I got lost.

Previously with the other script, I had it using GET and working as:

<?p
...
...
 echo "<a href=\"[url]/myscript.php?a=$row['parta']&b=$row['partb']\">Link</a>";
...
?>

Not sure if my description was clear enough, but thats what I needed to change.

[codeprada]

One submit button would suffice. The radio button would only need the ID of the row. All the information shown such as Title, parta, partb etc are for the users.

You're radio button after generated could look like this
<input type="radio" name="music" value="ROW_ID"> The ROW_ID is simply the primary key of your Music table. Within the script that accepts the form submission you would then get the value of the music radio button.

$value = $_POST['music'] //name of our radio button

Don't worry about all your radio buttons having the same name. This just let's the browser know that you can only select one radio button at a time. To get the information again a query with a WHERE condition will work.

SELECT * FROM Music WHERE ...

So you see you don't need to send parta and partb to the other script. The primary key should work just fine.

[blitzfx]

Thanks,

I managed to get what I needed with that bit of info