Table types

[WhiteCube]

hi,

 

I have a table with the type "int"... Its for an inventory script.. so.. Is there a special "table type" that i can use so if the amount of a certain item is zero or smaller.. is is automatically stripped from the table?

 

thanks!

[teng84]

you dont have to do it that all you need is a select statement that will display all the record with 0 inventory not delete it automatically.. but you can

[WhiteCube]

oh .. so there isn't anything already in MySQL (like the autoincrement) which deletes all records with "0"?

[teng84]

i believe yes..but you can delete all the zero item using delete query eg.. delete from table where id=0

[WhiteCube]

oh ok.. BUT.. I'll have to do it manually right? Unless i have cronjobs right?

 

lol Thanks for your info!

[teng84]

yep!  or just add it into your script so everytime you run your script it will return the zero id then delete