Error end of the page when recordset is empty

I receiving an error at the bottom of the page as:

Warning: mysql_free_result() expects parameter 1 to be resource, null given in /home/content/39/10368039/html/shrishtiartgallery/other-style-artworks.php on line 460


page is live here:

http://www.shrishtiart.com/other-style-artworks.php

THis error seems to appear only when recordset is empty.

File attached.

This error occurs because your ArtistName recordset is inside of a repeat region... so if there are no results the recordset doesn't end up being created.

The solution is probably to move the mysql_free_result() line from that recordset inside of the repeat region as well.

So move this line:
mysql_free_result($ArtistName);

inside of the repeat region just before line 335

i added on attached file. error doesnt seem to appear. but when i add to the to another page ie: where RS is not empty then shows another error.

<br />
<b>Warning</b>: mysql_fetch_assoc(): 12 is not a valid MySQL result resource in <b>/home/content/39/10368039/html/shrishtiartgallery/drawing-artworks.php</b> on line <b>345</b><br />
<br />
<b>Warning</b>: mysql_fetch_assoc(): 12 is not a valid MySQL result resource in <b>/home/content/39/10368039/html/shrishtiartgallery/drawing-artworks.php</b> on line <b>345</b><br />

I see... yes you can't free the result there because it is referred to again lower.

Move the code back to the bottom of the page and wrap it in an if statement instead like:


if (isset($ArtistName)) {
mysql_free_result($ArtistName);
}

to which line? shud i add these :

if (isset($ArtistName)) {
mysql_free_result($ArtistName);
}

i added at 340 line now. (file attached)

yet i m getting an error.

That code is right, but it needs to be moved back to the bottom of the page where it was before.

awesome (y)