Hi, I am Javed and am beginner in PHP and SQL. I have created a database in MySQL named SOFTWARE,
and I have these tables in it :
1. MAINLIB ( For keeping the names of IMAGE LIBRARY names )
Fields are a. newlibrary varchar(60)
b. idmain int(10) ( Primary key - Autoincrement )
2. UNDRLIB ( For keeping the names of IMAGE CATEGORY under library names )
----------
Fields are a. newcategory varchar(60)
b. idmain int(10) ( to relate it to MAINLIB )
c. idcat int(10) ( Primary key - Autoincrement )
3. DSGNLIB ( For keeping the names of IMAGES under selected categories and libraries )
----------
Fields are a. idmain int(10) ( to relate it to MAINLIB )
b. idcat int(10) ( to relate it to UNDRCAT )
c. smallthumblink varchar(60) ( to keep small thumbnail link names of images )
d. bigimageanddesc varchar(60) ( to keep big images link names and description )
e. iddsgn int(10) ( Primary ket - Autoincrement )
Now I want to give the preferances to the user to select a library name and category and accrodingly I want to
display small thumbnail images to the user. The problem is image library is bit big and I want to display
these images on subsequent pages. That is in first page suppose I want to display 10 images. Then when the
user press NEXT button it should display the next 10 images and so on. If the user press PREVIOUS button
then it should display PREVIOUS 10 images to the user. When the user right clicks on any of the images it
should provide a link to the BIG IMAGE FILE.
I dont know how to handle it, so can anybody guide me?
Thanking You. I remain
Javed.
