This error isn't true!

[cooldude832]

I get this error

Table 'db212911583.Events_new Where EventID = '293'' doesn't exist

the query is:

Select CreatorID From `Events_new Where EventID = '293'

 

and I checked my Events_new table and there is an EventID for 293 I'm confused ????

[cooldude832]

and its not a single row specific either I tried it on an another row that I know exist

[toplay]

If that's really your query, then you're missing a backtick mark after the table name. Change it to:

 

Select CreatorID From `Events_new` Where EventID = '293'

 

[rajivgonsalves]

the query seems to be wrong

 

Select CreatorID From `Events_new Where EventID = '293'

 

should be

 

Select CreatorID From `Events_new` Where EventID = '293'

 

observe the "`" character added

 

Cheer!

Rajiv

[teng84]

the query seems to be wrong

 

Select CreatorID From `Events_new Where EventID = '293'

 

should be

 

Select CreatorID From `Events_new` Where EventID = '293'

 

observe the "`" character added

 

Cheer!

Rajiv

 

that is mentioned already  read toplay post