Image_number = image_id + 1000

[Sun Zaza]

Hi,

I need your help to solve this issue:

I added a new column to my images table: image_number.

I want that the value of this field always: image_id + 1000. That means if image_id = 1 than image_number = 1001.

I really need some support guys.

I appreciate any help,

Cruxy

[AKIN]

testing pls


UPDATE 4images_images SET image_number = image_id + 1000, cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments, image_comments, image_downloads, image_votes, image_rating, image_hits

[Rembrandt]

Hi!

testing pls.....

Code: [Select]

UPDATE 4images_images SET image_number = image_id + 1000the other does not need you.

mfg Andi

[Sun Zaza]

Thanks for your help. It is already done.
Cruxy