Thanks for all the replies. The problem was an obvious one and i should
have picked it up.
It was the case was incorrect in some table names.
Worked fine local (windows apache), but when i put it on my website,
(apache / Linux) case was important.
Oli your advice was spot on, espacially the mysql_errror|() function
which gave me the name of the table at fault.