Please help with a command

programming
1

i currently have this in my php file.


mysql_query("UPDATE inventory SET id_num ='$id_num' WHERE id_num ='$id_num'");
mysql_query("UPDATE inventory SET id_asset ='$id_asset' WHERE id_num ='$id_num'");

instead of updating this tables how do i set it up for deletion?
i’m still new to php and i thought this would work.

mysql_query("DELETE FROM inventory SET id_num ='$id_num' WHERE id_num ='$id_num'");
mysql_query("DELETE FROM inventory SET id_asset ='$id_asset' WHERE id_num ='$id_num'");

but it doesn’t unfortunately.

any help will greatly be appreciated.
thank you

2

DELETE FROM inventory WHERE id_num = ‘$id_num’;

3

[QUOTE=sekasi;2331008]DELETE FROM inventory WHERE id_num = ‘$id_num’;[/QUOTE]
thank you that worked.
question, i have a bunch of tables i would like to delete at one given time, is it possible to combine a deletion of multiple tables at one given time?

[QUOTE=TheColonial;2331493]cool… let me know what the URL is when you’re done. Then i can browse to it like so:

http://your_url/file.php?id_num=’;DROP%20TABLE%20inventory;[/QUOTE]

this is not up on an actual server.
this is set up on a local machine.

4

wanna to play age of conan gold [url=http://www.igxz.com/age-of-conan-gold-s.html]aoc gold [url=http://www.igxz.com/]lotro gold [url=http://www.lotro-sale.com/age-of-conan-gold/]age of conan gold [url=http://aoc.rgtr-credit.com/]age of conan gold??