Guest User

Untitled

a guest
Aug 3rd, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. php mysql_fetch_assoc isn't working as expected
  2. $username = trim(mysql_real_escape_string($username));
  3. $password = md5(trim(mysql_real_escape_string($password)));
  4. $query = "SELECT user_level FROM user WHERE username='$username' AND password='$password'";
  5. $result = mysql_query($query) or die('query did not go through');
  6. if($result!=false){
  7. echo 'result is not false!<br/>';
  8. while($row = mysql_fetch_assoc($result)){
  9. echo 'another output to test'.$row['user_level'].'<br/>';
  10. }
  11. }
  12.  
  13. $query = "SELECT user_level, username FROM user WHERE username='$username' AND password='$password'";
  14.  
  15. $query = "SELECT user_level, username FROM user WHERE username='$username' AND password='$password'";
  16. echo $query;
  17.  
  18. while($row = mysql_fetch_assoc($result)){
  19. print_r($row);
  20. }
  21.  
  22. $query = "SELECT user_level FROM user WHERE username='$username' AND password='$password'";
  23.  
  24. while($row = mysql_fetch_assoc($result)){
  25. echo 'another output to test'.$row['user_level'].'<br/>';
  26. }
  27.  
  28. while($row = mysql_fetch_array($result)){
  29. echo 'another output to test'.$row['user_level'].'<br/>';
  30. }
Add Comment
Please, Sign In to add comment