Author Topic: Picture Number  (Read 4088 times)

0 Members and 1 Guest are viewing this topic.

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Picture Number
« on: September 24, 2005, 07:44:21 PM »
Hi

Each picture get a number. This is a uniq key. If I delete a picture, will this key (number) be available for a new picture?
Let's say I have a picture with the name "house". The picture number is 5.
Now I delete this picture and upload a new picture.
Is it possible, that this new picture gets the picture number 5?

TIMT

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: Picture Number
« Reply #1 on: September 24, 2005, 07:55:53 PM »
no, it will not be avalable, in fact it would be not practical and might bring people to a confusion, when they try to access a picture that was deleted and now replaced by another one.
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 TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: Picture Number
« Reply #2 on: September 24, 2005, 07:58:47 PM »
your right! that's ok for me!

another question: i have a field "price" in my database. now I want to change the value of this field from 3.50 to 2.50 in all records. Can you tell me, how I can do that?

Thanks

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: Picture Number
« Reply #3 on: September 24, 2005, 09:58:23 PM »
mysql query:
Code: [Select]
UPDATE 4images_images SET price = "2.50" WHERE price = "3.50"
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)