radio buttons on fetched data

[jaguarpk786]

ive this code which fetches track title and artist name from the database ,,,, i want to insert radio button in front of each fetched row through which user wud b able to select a song which he wants to download

<?php
 
 
include 'oracleconn.php';
 
 
 
  $conn = connect();
 
 
$query = 'select ttitle, artist from Track';
$stid = oci_parse($conn, $query);
$r = oci_execute($stid);
 
// Fetch the results in an associative array 
    print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS+OCI_ASSOC)) {
   print '<tr>';
 
   foreach ($row as $item) {
      print '<td>'.($item?htmlentities($item):' ').'</td>';
   }
   print '</tr>';
}
print '</table>';
 
// Close the Oracle connection
oci_close($conn);  
 
 
?>
     <p>&nbsp; </p>

[Markus]

jaguarpk786, this is your second warning on using [code] tags (or more fittingly: not using [code] tags). It is against forum guidelines to post code without using code tags. Continue to do this, and you will receive a ban of some sort.

Please review the posting guidelines to avoid this action being taken.

MODERATOR.

[nathj]

It's seems like a nice idea, just do it.

As you are using tables (aarrghh) simply add another row on the left or right contain these input controls and then in your code populate the elements with input controls.

Based on the code I read it looks to me like you would be better off with check boxes. they would certainly be easier if you want multi-selection facility. If I've mis-understood that part of it and it is a forced single selection then you will want a radio button but with your layout the code is going to be awful.

If you need a tutorial on either of these controls head over to W3Schools HTML tutorial

Have a go and let us know how you get on - posting final code in code tags!

nathj