Edit: all the retrieval code is there too for reference
Code: Select all
print "<center><br><h3>Rest & Rehab</h3></center>";
print "<center>";
print "<table border='0' width='70%' cellspacing='20'>";
print "<tr><td width='25%' valign='top'>";
print "</td>";
print "<td valign='top' width='75%'>";
print "<table border='1' bordercolor='black' bgcolor='#ffffff' >";
print "<tr><td>Name<font color='ffffff'>_________________</td><td>Rating<font color='ffffff'>___</td>
<td>Development<font color='ffffff'>_</td><td>stamina<font color='ffffff'>_____</td></tr>";
print "<tr><td>Rest</td>
<td>$playerinfo3[rating]</td><td><select><option>$ainfo3[name] $ainfo3[level] $ainfo3[cost]</option></select></td><td>$playerinfo3[stamina]%</td></tr>";
print "<tr><td>Rear Wing</td>
<select><option>$ainfo3[name] $ainfo3[level] $ainfo3[cost]</option></select>
what i am trying to do is create a drop down menu in my table whilst restricting the data received it is showing the corresponding information but only one in the list not both
so for instance in phpmyadmin
i have:
name id level price
Rest 1 2 20
Sleep 1 3 40
Chill 2 2 20
lounge 2 3 40
i want to only see items on this list where id=1 and the corresponding name and price of the action.