$query = "select * from userlist where username = '$lune' ORDER BY id DESC LIMIT 1"; $result = mysqli_query($link, $query); $row = mysqli_fetch_array($result); echo $row['gangwei'];