i have got the code working the problem was it was showing the table but no data i fix that there was an error on this line of code
while($row = @mysql_fetch_array($result));
it should have read
while($row = @mysql_fetch_array($result))

thanks for the help it is much appreciated
mike

__________________

---