I would also recommend having two different messages for mysql_conntect and mysql_select_db so you can see which function is not working correctly.

Ah, if it in a page added through wordpress rather than the template add this code to just above the displayCounter function

add_shortcode('displayCounter','displayCounter');

And just put this on the wordpress page: [displayCounter]

Firstly make sure there is no spaces in the <?=displayCounter();?> code, and make sure the template where you are adding it to is PHP like header.php

The main option I can think of is to have two seperate files one which has the table and the other which displays the image.

<?php
$hostname = "shopbyclickorg.ipagemysql.com";
	$username = "shopbyclickorg";
	$password = "*********";
	if(!($link = mysql_connect($hostname,$username,$password)))
	      die("Could not connect to database.");
	$databasename = "e_commercedb";
	if(!(mysql_select_db($databasename,$link)))
	      die("Could not open table."); 
$result =mysql_query( 'select * from product');
print "<table>"; 
while ($row = mysql_fetch_array( $result ))
{  
?>
<tr>
<td width ="60" height ="60">
<img src="images.php?id=<?=$result["id"];?>">
</td>
</tr>
<?php
}
?>

image.php

<?php
$hostname = "shopbyclickorg.ipagemysql.com";
	$username = "shopbyclickorg";
	$password = "*********";
	if(!($link = mysql_connect($hostname,$username,$password)))
	      die("Could not connect to database.");
	$databasename = "e_commercedb";
	if(!(mysql_select_db($databasename,$link)))
	      die("Could not open table."); 
$result =mysql_query( 'select * from product where id = '.$_GET["ID"].' LIMIT 1;');
$result = mysql_fetch_array($reult);
header("Content-type: image/jpeg");
echo $result['image'];
?>

This code should do it.

As you have trouble with this I suggest you consider creating a plugin for this. Which would enable you to fairly easily change templates.

so in the wp-contents/plugins/ create a new folder called travelcounter and inside there make a file called travelcounter.php and save the code in it:

<?php

	/*
	Plugin Name: TravelCounter
	Plugin URI: 
	Description: 
	Version: 1.0
	Author: 
	Author URI: 
	*/
	
	function displayCounter(){
		// your code goes here
	}

?>

Then activate the plugin in the wordpress plugin section.

And in the template wherever you want it to go just place this code <?=displayCounter();?>. So if you change template all you need is to put that bit of code in the place you want it.