[SOLVED] help needed

[whizzykid]

I created this and when i try to use the login in form it shows table doesnt exist.

This is my code.

where it always point to.

$LoginRS__query=sprintf("SELECT Login,Password FROM Customer Login WHERE Login=%s AND Password=%s",

 

helpppp

 

[Ken2k7]

Remove the Login before WHERE. The table is just called Customer right?

[whizzykid]

No the table name is  Customer Login.

[Ken2k7]

You have a space in your table name?

 

Put backticks around the name.

[premiso]

Not that I suggest using spaces in table names (infact I would avoid it at all costs) but this would fix it:

 

$LoginRS__query=sprintf("SELECT Login,Password FROM `Customer Login` WHERE Login=%s AND Password=%s",

 

The backtick (`) will be needed whenever you call that table name because of the space.

[whizzykid]

Yes i have space btw the name.And thank you i hv included the back ticks and it works now.Wow 2nd problem solved.this is so cool.Thanks ken.