Author Topic: remove range of image_id's  (Read 5119 times)

0 Members and 1 Guest are viewing this topic.

Offline edwin

  • Full Member
  • ***
  • Posts: 199
    • View Profile
    • http://www.foto-janssen.nl
remove range of image_id's
« on: April 21, 2005, 09:10:56 PM »
I have noticed that i have a range of image-id that not contain a a picture or info
Now i want to remove them, how can i do this the best way, with PHPadmin?

there 41000 picture on my website but the image_id go from 0 until 104000

with regards Edwin


Offline ManniC

  • Full Member
  • ***
  • Posts: 182
    • View Profile
    • photographic impressions
Re: remove range of image_id's
« Reply #1 on: April 21, 2005, 09:35:47 PM »
Hi Edwin,

the reason is: By deleting an image the ID remains reserved. There is no continuous range of unused ID's.
Viele Grüße / Best Regards
Manfred
------------------------------------------------------
photographic impressions powered by mc-com.de[/color][/url][/size]

Offline edwin

  • Full Member
  • ***
  • Posts: 199
    • View Profile
    • http://www.foto-janssen.nl
Re: remove range of image_id's
« Reply #2 on: April 21, 2005, 09:42:33 PM »
oke, but if bye example Google or another searchmachine indexes my website, it still will see my reserved image_id?

And what if i still want to remove them, can i expect troubles and if no, how can you this the best

Offline Chris

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.487
  • Did u ever stop to think and then forget to start?
    • View Profile
Re: remove range of image_id's
« Reply #3 on: April 22, 2005, 12:29:42 AM »
oke, but if bye example Google or another searchmachine indexes my website, it still will see my reserved image_id?

No because the image page doesn't exist anymore.  Therefore Google can't index it.

And what if i still want to remove them, can i expect troubles and if no, how can you this the best

They are already removed!  You won't find them in your database.  The image id is an auto_increment data type. This means the number is incremented every time a new row (image) is added.  The number never repeats or gets used again.  Your image ids are not contiguous. http://dictionary.reference.com/search?q=contiguous

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: remove range of image_id's
« Reply #4 on: April 22, 2005, 03:53:14 AM »
also, if u would use deleted image ids then it might bring a chaos when search shows one image (the old cached) and in real there is something else...see what I mean?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline edwin

  • Full Member
  • ***
  • Posts: 199
    • View Profile
    • http://www.foto-janssen.nl
Re: remove range of image_id's
« Reply #5 on: April 22, 2005, 01:59:05 PM »
Yes, thank you very much, guys