If you want the where to be contingent upon all the AND statements put them in parens.
eg:
WHERE (
AND a.paksh = b.paksh
AND a.tithi = b.tithi
AND b.date BETWEEN CURdate( )
AND (CURdate( ) +9)...

Take the table out of the while loop.
Use the while loop to create your image array.

$i=0;
while ($rows = mysql_fetch_array ($Img_result, MYSQL_ASSOC))
{
$imageArray=$rows['filename'][$i};...

The reason you are only showing one file over and over is due to this line:

$realname = $rows ['filename'];

You need to tell it to iterate through the results array. You should keep a counter...

Are you saying you want 3 images per table row?
If this is what you want to do, you may also want to change your limit on the query results to 6.

Then you would put your table creation inside of...

You need to do:
#content a:link{
color:blue
}

That will change all link color inside of the content div

Do a search for lightbox or shadowbox or greybox.

Many of these have been made and are available for free downloads.