I am trying to delete some categories and their corresponding links from a Links SQL database between a certain range of FatherID's but I can't seem to get the syntax right could someone help please.....
The FatherID's are 5806 to 13487. Is there an easier way to do this?
I've tried some things but can only get it do delete certain categories and not their corresponding links....
DELETE * FROM Category WHERE FatherID="number";
I can't seem to get it to delete a range of categories and the corresponding data.
Thanks.
Oh I've also tried this but it just brings up the whole category and not the specific data......
SELECT * FROM Category WHERE (FatherID>"5805" & FatherID<"13488");
Maybe I just don't know much about MySQL queries
Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/
The FatherID's are 5806 to 13487. Is there an easier way to do this?
I've tried some things but can only get it do delete certain categories and not their corresponding links....
DELETE * FROM Category WHERE FatherID="number";
I can't seem to get it to delete a range of categories and the corresponding data.
Thanks.
Oh I've also tried this but it just brings up the whole category and not the specific data......
SELECT * FROM Category WHERE (FatherID>"5805" & FatherID<"13488");
Maybe I just don't know much about MySQL queries
Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/