Mac the problem is that when I click on the edit link in the list_players page, the edit form comes up empty as if there are no records the database.
And the echo statement output "Number of rows: 0. Question is why zero rows when there is data in the database
Language: PHP
//get value of id
$player_id = $_GET[';player_id';];
//update data in database
$query = "UPDATE playerinfo SET name = ';$name';, surname = ';$surname';, contactnumber = ';$contactnumber';, email = ';$email';, position = ';$position';, username = ';$username';, password = ';$password'; WHERE player_id = ';$player_id';";
//retrieve data from database
$query = "SELECT * FROM playerinfo WHERE player_id = ';$player_id';";
$result = mysql_query($query)
or die("Query failed: ".mysql_error());
$num = mysql_numrows($result);
echo "Number of rows: $num";
$i = 0;
while($i < $num){
$name = mysql_result($result,$i,"name");
$surname = mysql_result($result,$i,"surname");
$$contactnumber = mysql_result($result,$i,"contactnumber");
$email = mysql_result($result,$i,"email");
$position = mysql_result($result,$i,"position");
$username = mysql_result($result,$i,"username");
$password = mysql_result($result,$i,"password");
$i++;