radio button/form question..MySQL

[Anon]

Having trouble getting this to work.

my first page has the whole database shown in table format...and to the left of all the rows is a Radio button.

I want to be able to click the radio button and
I want the radio button to have the value of whatever ID number it was next to.

so I did this..inside the while loop..

print "<tr><td><INPUT TYPE = RADIO NAME = $PlayerID VALUE = $line[0]></td>";

so $line = mysql_fetch_array($result);

on my Next page...
its supposed to run a querry..so that I pick the record that matches the chosen radio button with the ID number. (call it pno)

$querry = "SELECT pno, fname, lname FROM info WHERE '$PlayerID' = pno";
$result = mysql_query($result) or die("didnt work");

And then I have a form
<FORM>
<tr><td>Last name: <td><td><INPUT TYPE="text" NAME = $lNAME VALUE = $line[2]><td></tr>
</FORM>

I know that last part is wrong because it just prints $line[2] (I didn't put <? ?> around it cuz I'm not sure how exactly, when I put it around it I get a parse error.

but I did it somhow and it didn't print anything.

What am I doing wrong? and when I make a Radio button/button or whatever should I define the name with the $ in front of it?
or should I just define the NAME with " " around it?

also do you think my Querry is even doing what I wanted it to do? or is it selecing nothing? (hence why I get nothing printed?

thanks for any help..

[Anon]

I figured it out its my select statment.

$query = "SELECT pno, fname, lname FROM info WHERE pno = '$PlayerID'";

I tried it with pno = 'P4' hard coded and it worked fine, it showed the player I wanted it too.

so somehow $PlayerID is not getting the value from the Radio button or something, I'm doing something wrong with that.

Thanks, its probably simple I just am not sure what I'm doing wrong.

[Anon]

it should be

<INPUT TYPE = RADIO NAME = PlayerID VALUE = $line[0]>

(no $ on playerid)

and be VERY careful with that syntax.

i would code this:

echo "<INPUT TYPE='RADIO' NAME='PlayerID' VALUE='".$line[0]."'>";

[Anon]

Ok so here is most of my code that prints out the table of the database..

for some reason the part where I put $line[0]
is not being set to anything.

I tried print "$line[0]"; right after my radio type thing just to see if it had any value in it. and nothing printed....
so I'm pretty sure thats where my problem is.? how can I fix it.

while($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "\t<tr><td><INPUT TYPE = RADIO NAME = PlayerID VALUE = $line[0]></td>\n";
//////////I tried print "$line[0]"
foreach ($line as $col_value)
{
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}

[matto]

at a glance - first:

if you use MYSQL_ASSOC, access the field data not by numbers (print($field[0])) but by their field names:
print($field["thename"]);

alternatively, you can delete the MYSQL_ASSOC parameter. then it should work.

then:
in html tags, don't put spaces around the =.

furthermore:
<input type=radio name=this value=that>
this produces a variable named $this with the value "that". you've mixed this up.

HTH

[Anon]

I can't do that.
put " " inside the [] or it gives a parse error.

[Anon]

I figured out how to make it work.

Thanks!