4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: Sun Zaza on October 09, 2009, 05:50:52 PM

Title: Image_number = image_id + 1000
Post by: Sun Zaza on October 09, 2009, 05:50:52 PM

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

Title: Re: Image_number = image_id + 1000
Post by: AKIN on October 09, 2009, 06:57:04 PM

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

Title: Re: Image_number = image_id + 1000
Post by: Rembrandt on October 09, 2009, 08:20:20 PM

Hi!

Quote from: AKIN on October 09, 2009, 06:57:04 PM

testing pls.....

Code: [Select]

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

mfg Andi

Title: Re: Image_number = image_id + 1000
Post by: Sun Zaza on October 15, 2009, 09:41:48 AM

Thanks for your help. It is already done.
Cruxy