Help Rotation script !not random!

Flashbstudios

I need a code on making a rotation script
like to make img1.jpg than switch ot 1mg2.jpg and so on and at the end start over can you help me? 😕

LordShryku

Do you have a database to work with here?

If so, I'd create a table like this

CREATE TABLE images (
    id int(11) NOT NULL auto_increment
    image_name varchar(30) NOT NULL 
    active char(1)
    PRIMARY KEY (image_name)
)

Put all your image names in there. They will be assigned an id. On the first image, set active='Y'. So then all you need to do is select the current image, get the next one in line, update it to active, and so forth. If this is viable, and you need help with the code, just lemme know

Flashbstudios

CREATE TABLE images (
id int(11) NOT NULL auto_increment
image_name varchar(30) NOT NULL
active char(1)
PRIMARY KEY (image_name)
)

do you do this code for every image? Image_name is the URL right?

LordShryku

No, you only do this once to create the table in the database....

Then you fill it with INSERT statements. For the first image, do this

INSERT INTO images (image_name, active) 
VALUES ('nameOfImage.extension', 'Y')

For the rest of them, just

INSERT INTO images(image_name)
VALUES ('nameOfImage.extension')