Hi all,
I need some help with a mysql query...
i have a db full of records like:
id - searchterm - location - date
1 - ipod - us - 24/11/2007
2 - iphone - us - 24/11/2007
3 - - us - 24/11/2007
The id column is an auto-increment, so increases everytime a search is completed and logged. However, occasionally some users don't enter a search term, so I've ended up with an incorrect number of searches compared to search numbers (as in example 3 above)
I've been doing my own head in trying to work out how to reset the auto-increment after i've removed all the blank searches.
I hope i've explained it well enough... can someone help?
I need some help with a mysql query...
i have a db full of records like:
id - searchterm - location - date
1 - ipod - us - 24/11/2007
2 - iphone - us - 24/11/2007
3 - - us - 24/11/2007
The id column is an auto-increment, so increases everytime a search is completed and logged. However, occasionally some users don't enter a search term, so I've ended up with an incorrect number of searches compared to search numbers (as in example 3 above)
I've been doing my own head in trying to work out how to reset the auto-increment after i've removed all the blank searches.
I hope i've explained it well enough... can someone help?