following codes is working well on cPanel based account, but not on h-sphere. I would really appreciate any help / hints from you to fix this issue. Because my new host is using h-sphere.
<?
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$query = "SELECT itemno, viewed, stock, vin, year, make, status,model, condition, mileage, price FROM $dbvin ORDER BY $sort $order";
$result = mysql_db_query($dbname, $query, $link);
$n = 1;
while($data = mysql_fetch_array($result)) {
if(!($n % 2)) { $bg = "class='fill_light'"; } else { $bg = ''; }
echo "
<tr $bg>
<td class='text'>$data[stock]</td>
<td class='text' align='center'>$data[year]</td>
<td class='text'>$data[Brand]</td>
<td class='text'>$data[model]</td>
<td class='text' align='center'>$data[cond]</td>
<!--<td class='text' align='center'>$data[Km]</td>-->
<td class='text' align='center'>$data[Rate]</td>
<td class='text' align='center'>$data[stat]</td>
<td class='text' align='center'>$data[seen]</td>
<td class='text' align='center'><a class='link' href='detaillist.php?itemno=$data[itemno]'>Modify</a></td>
</tr>
";
$n++;
}
mysql_close($link);
?>