netjunky

user deletion

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