Guest User

Untitled

a guest
Jul 21st, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. $query="select idtechnic from technic where idname='$technic' and setname='$set' and number='$number'";
  2.  
  3. $result=mysql_query($query);
  4. $row1=mysql_fetch_assoc($result)
  5. $query1="select idtechnic, move from moves where idtechnic='$row1[0]' order by idmoves";
  6.  
  7. SELECT moves.idtechnic, moves.move
  8. FROM moves
  9. INNER JOIN technic
  10. ON technic.idtechnic=moves.idtechnic
  11. WHERE technic.idname='$technic'
  12. AND technic.setname='$set'
  13. AND technic.number='$number'
  14. ORDER BY moves.idmoves
Add Comment
Please, Sign In to add comment