Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. <?php
  2. $result1 = mysql_query('SELECT * FROM products WHERE IPC_artikelnummer=0');
  3. $result2 = mysql_query('SELECT * FROM products WHERE products_model='.$result1["products_model"].' AND IPC_artikelnummer NOT LIKE AND products_id<>'.$result1["products_id"]);
  4. $result3 = mysql_query('UPDATE products SET `products_quantity`='.$result2["products_quantity"].', `products_status`=1, `IPC_artikelnummer`='.$result2["IPC_artikelnummer"].' WHERE products_id='.$result1["products_id"].' LIMIT 1');
  5. $result4 = mysql_query('DELETE FROM products WHERE products_id='.$result2["products_id"].' LIMIT 1');
  6. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement