[eluser]tuckee[/eluser]
Hi,
To load my front page, I have to go through the database retrieve information and load it to front page.
I got the following error as below:
A Database Error Occurred
Error Number: 1146
Table 'picknsha_sponsorsys.Advertisement' doesn't exist
SELECT * FROM Advertisement WHERE ads_status=1 ORDER BY ads_name limit 3
is quite obvious why the error occur, is because table 'picknsha_sponsorsys.advertisement' doesn't exist. The proper table should just be table 'advertisement'.
'picknsha_sponsorsys' is the name of my database.
my question is why would the system put the database name before the table name 'advertisement'
if i were to run on local machine, i do not have this problem.
do u have any idea how can i solve this problem?