mySQL max value help

[briangregoryfish]

hi folks. i'm having an issue with the max value in my pixelpost_pixelpost section of my database, where the photos are stored. because of having to delete a few images from my site, the numbering is now off. for instance, the link to image 175 says "..showimage=175", but the link to image 176 jumps to "..showimage=178". i found out how to manually change them in the mySQL admin page, but i can't figure out how to change the max value so it will automatically line the numbers up correctly. any ideas on how to fix this? thanks.

http://shadowofadoubt.net

-brian

[GeoS]

What for do you need numbers one by one?? It's only for PP to know what it should to show for user watching your blog. There isn't any other ideology in it!!!

[briangregoryfish]

i name my photos by number, so i'd like the number in the address bar to be the correct number of the photo, because otherwise everytime someone orders a print from my site, and says they want, let's say, image 215, i have to ask them if they really want image 215, or if they want image 213, or maybe 218, because the number in the address bar is off by a couple numbers from the title of the image in the archives.

[GeoS]

So if you say that numer in the address bar is off for a while it makes risk of mistake numer less then with order of numbers one by one. I dont get it :/

Add info about filename, attache link to thumbnail and file title instead of only number in blog and all will be OK. Try to make better ordering process instead of playing with numbers:) If you dont want do it then you must handle by yourself this problem (which really isnt any problem).

[briangregoryfish]

thanks anyway for your lack of help.

[GeoS]

Any help is that you can do it only from SQL level (i.e. phpMyAdmin and so on).

[briangregoryfish]

Any help is that you can do it only from SQL level (i.e. phpMyAdmin and so on).

yes, that's what i'm asking... does anyone know how to change the max value at the SQL level using phpMyAdmin so the numbering is no longer off? thanks.

[GeoS]

To start with an AUTO_INCREMENT value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

mysql> ALTER TABLE tbl AUTO_INCREMENT = 100;

PS Do you use sometimes google and etc.?? Its good to know how does it work :)

[briangregoryfish]

PS Do you use sometimes google and etc.?? Its good to know how does it work :)

it would be nice if a "help forum" actually offered help, instead of patronizing insults. i will look elsewhere for future help. thanks.

[GeoS]

But that isnt PP problem but generaly SQL problem.

There are many other very useful and easy to use knowlage sources but users dont use them :/

Anyway sorry - maybe it was my bad day.