Ok, I have vBStats installed on my board and I skipped one step accidently until about a few days later. That step was to add the ability in the admin center to do stuff like remove a URL from inclusion in the referrers thing and you were supposed to do that to your own domain. Well, after 3 days of waiting and finally doing it, I got 3303 hits from my own domain. How would I delete the first line:
from the database and have all of the ['id'] numbers go down one? So what query would I run to delete that row and bring all of the other rows' ID numbers down one?
Edit: Lol, haha, nevermind, I'm a retard. I got it, ignore the rest of this post.
Cool. Ok, my table for that is 'vbstats_referrer' so how would that query run? When I ran it like this:
DELETE FROM tablevbstats_referrer WHERE idField = 1;
It doesn't work... I also tried a space between 'table' and 'vbstats_referrer' but that didn't work.... I tried a period (.) between 'table' and 'vbstats_referrer'. Heh, sorry... not very good with mySQL. I wanted to buy a book on it a few days ago, but it was $40.
05-20-2002, 08:16 PM
What Query To Run?
I wanted to buy a book on it a few days ago, but it was $40. 
Linear Mode
