netjunky

user deletion correct

Mar 1st, 2011
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.29 KB | None | 0 0
  1. $query->( "
  2. DELETE
  3.     U, SB, S, O
  4. FROM
  5.     users AS U
  6. LEFT JOIN
  7.     shopping_bag AS SB
  8. ON
  9.     SB.id = U.id
  10. LEFT JOIN
  11.     settings AS S
  12. ON
  13.     S.id = SB.id
  14. LEFT JOIN
  15.     orders AS O
  16. ON
  17.     O.id = S.id
  18. WHERE
  19.     U.id = " . MySQLiDatabase::getInstance()->escapeValue( getPost( 'selected_user' ) ) . "
  20. " );
Add Comment
Please, Sign In to add comment