Need help with sql/php and pictures
Posted: Fri Jun 25, 2010 11:32 am
Hey everybody!
Am new on this forum and would like to have some help, its a thing that ivent done yet, but would like to learn, and that is to take out UNIQUE pictures on each site, and then echo them.
Does it have to do with "LIMIT" in SQL or?
There is 6 pictures named pic1, pic2, pic3 and so on.
Ive 2 pages that have a "next button" right next to the pictures, what i want it to do is take out 3 unique on each site (ofcourse there is going to be more pictures than 6, but you get the point i hope
)
any tip on how to make this possible?
Oh and sorry for the bad explanation, but i hope you get it somewhat good atleast.
Step 1: Take out 3 pictures from database
Step 2: echo them on the first page
Step 3: press "next" button and go from the first page to the second page
Step 4: 3 new pictures comes that are not the same on the second page (page id=2 or something)
I know that this normally is possibly with HTML code, but this is more convienient with php code/sql if i have 40 pictures or something.
hope i explained it good enough, great forum btw!
Greets :
Phpfreak2000
Am new on this forum and would like to have some help, its a thing that ivent done yet, but would like to learn, and that is to take out UNIQUE pictures on each site, and then echo them.
Does it have to do with "LIMIT" in SQL or?
There is 6 pictures named pic1, pic2, pic3 and so on.
Ive 2 pages that have a "next button" right next to the pictures, what i want it to do is take out 3 unique on each site (ofcourse there is going to be more pictures than 6, but you get the point i hope
any tip on how to make this possible?
Oh and sorry for the bad explanation, but i hope you get it somewhat good atleast.
Step 1: Take out 3 pictures from database
Step 2: echo them on the first page
Step 3: press "next" button and go from the first page to the second page
Step 4: 3 new pictures comes that are not the same on the second page (page id=2 or something)
I know that this normally is possibly with HTML code, but this is more convienient with php code/sql if i have 40 pictures or something.
hope i explained it good enough, great forum btw!
Greets :
Phpfreak2000