Updating Discount Code Table Error
I have the attached confirm.php page. See the PM for the error I am getting. I added two server behaviors to this page that is likely causing the error. First, I want to locate the recordset "discounts" based on the session variable "PromoCode". Next, I want to update that recordset field "discountStatus" with the number 1 if the order submission is successful. The errors I am getting are:
Warning: mysql_select_db() expects parameter 2 to be resource, null given in /home/content/05/11651305/html/(my domain folder)/confirm.php on line 44
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/05/11651305/html/1to1-silpada/confirm.php on line 16
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/content/05/11651305/html/(my domain folder)/confirm.php on line 16
Warning: mysql_query() expects parameter 2 to be resource, null given in /home/content/05/11651305/html/(my domain folder)/confirm.php on line 46
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)