hi there !!

I want to do something like this..

I am generating one report which contain few images..what i want to do is.. if user click on one particular picture.. next time the picture will replace with new picture and new hyperlink. How i can do it ?

Please suggest !!

With thanks

There are two ways
1. serverside scripting e.g. php, asp: Generate a .asp or .php page with a picture. If the picture is clicked the same page must be requested but with a parameter that refers to the next picture. The parameter must be handled by the asp or php module webserver.
2. client side scripting: Make a page that contains the pictures. Make all pictures but one hidden. Write a javascriptprocedure that hides the current picture and shows the next. Call this procedure in the onclick event of the picture.

Thanks for your reply.. !!

I was getting little bit from your response. Would you like to eloborate a little more ? Please !!!

I am using ASP and SQL Server 2000. I am fetching the records from one sql table..

Hope this time, i am bit clearer..

With thanks

Say you want a 5x5 grid of images;

LIMIT may be TOP or something in M$SQL... but I can't remeber

Right anyway,


each image should have a link to whereever - but - tag on the end of it something like this
(obviously replacing 3 with the value from the id column for the current row).

whatever page the user links to needs to keep that paramenter in the querystring (asp)/get variables (php) for when the user navigates back to the image grid page.

Now, in the query from eariler you need to change 3 to the value of that parmeter.

Summary (psuedo code)
Hope that makes sense, it was typed in a rush

Thanks !! You eloborated it quite nicely.. and I got it quite clearly what i have to do.. Thanks !!

There is one more issue related to image hyperlink.. I was making one report named "review report" .. What i want in it is.. as soon as the user clicks on the particular records ( i mean to say.. when he/she viewed it) the image associated with that record will replace with new image..

In any of mine tables no such fields are there which store such status.. wether the records has been reviewed or not ? If i have to go thru that method then please explain.. How i can do it ?????

Are there some other method also thru which i can do it ?

With thanks !!

Not quite sure what you mean but here it goes;

You can store a list of what the user has viewed in either the session variables or a cookie or such like. Remeber sessions/cookies can be "lost" (deleted/cleared/ended by the user) - so keeping it in the database (or a file or such like) may be your only option if you need to keep a track of what they have viewed.

This is pretty easy to do, but could have a performance hit if your constantly saving lots of data.

It seems you are not getting what i seek... let me explain again..

I have to make one report in which all the events related to particular campaigns are going to display.. Every record has one picture which gives the idea whether someone view that record or not... In order to view the details of events user has to click on the graphic icon associated with that record..

Now, I want to keep whether records has been viewed by someone or not.. if it was views then i have to display other pciture..

Hope this time, I explained well...

With thanks !