IP ORDER 1.0 Syntax Error

[Guest]

Hi guys!

 

 

I need a little help with this one.. here goes...

 

First, I should mention this, While working on my new site that is currently IP based and no domain attached at present. So please don't go to the site listed in my info.. thanks..

 

 

I placed a few orders and used Check/Money order in order for the IP and ISP to be recorded.. Because for one, the IP and ISP recorder does not record when a customer chooses to use PayPal as payment method..

 

Second, after my test order was placed.. I went into admin section to view the order and see how all was.. When I went to update the order .. And what I mean is update from "Pending" to Processing". I got this error immediately..

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ipaddy, ipisp orders where orders_id = '9'' at line 1

 

select customers_name, customers_email_address, orders_status, date_purchased from, ipaddy, ipisp orders where orders_id = '9'

 

[TEP STOP]

 

Can anyone please explain to me what this means exactly? And please tell me how to fix it please..

Otherwise, the contribution is awesome! And makes things more efficient.

 

Thanks in advance,

 

Christine