Forum Moderators: coopster

Message Too Old, No Replies

T CONSTANT ENCAPSED STRING error

         

stevey2005

11:32 am on Aug 18, 2006 (gmt 0)

10+ Year Member



$SQL = 'UPDATE addresses SET ip_address="'.$ipaddress.'",.$date_issued="'.$date."', comments="'.$comments.'", business_name="'.$businessname.'", uusrp_centre="'.$centre.'", businesslocation1="'.$location1.'",
businesslocation2="'.$location2.'", business_email="'.$email.'"
WHERE ip_id='.$uid;

Canyone help me with this piece of code.

I've ensured that the table name matches with whats in the database and ensure that all spelling matches.

It seems that .$date_issued="'.$date."' causes the problem

dreamcatcher

1:20 pm on Aug 18, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi stevey2005,

Welcome to Webmaster World. :)

You have a mismatch of quotes:

"'.$date."'

dc