Printable View
hi
i am adding a field "compatibility" to my query but everytime i m getting unexpected t_string error
help me remove this error. This field is "varchar".PHP Code:values('$unique_id',$order_id,'$username','$log_id','$shop_date','".$row['product_name'] . "' , " . $row['quantity'] . "," . $row['shipping_cost'] . ",". $row['price'] .",". $row['total_cost']. ",". '". $row['compatibility'] . "'. ")";
vineet
Could you post the complete query please?
here it is
PHP Code:$order_detail="insert into detail_table(unique_id,order_id, customer_name, customer_login_id, order_date, product_name, quantity, shipping, price,total_cost,compatibility)
values('$unique_id',$order_id,'$username','$log_id','$shop_date','".$row['product_name'] . "' , " . $row['quantity'] . "," . $row['shipping_cost'] . ",". $row['price'] .",". $row['total_cost']. ",". '". $row['compatibility'] . "'. ")";
mysql_query($order_detail);
its your quotes that are all messed up.
PHP Code:values("
'$unique_id'
,$order_id
,'$username'
,'$log_id'
,'$shop_date'
,'".$row['product_name'] . "'
,'" . $row['quantity'] . "'
,'" . $row['shipping_cost'] . "'
,'" . $row['price'] ."'
,'" . $row['total_cost']. "'
,'" . $row['compatibility'] . "'");
hi Spikez
i copied your code but its not showing correctly at my end
vineetPHP Code:$order_detail="insert into detail_table(unique_id,order_id, customer_name, customer_login_id, order_date, product_name, quantity, shipping, price,total_cost,compatibility)
values("
'$unique_id'
,$order_id
,'$username'
,'$log_id'
,'$shop_date'
,'".$row['product_name'] . "'
,'" . $row['quantity'] . "'
,'" . $row['shipping_cost'] . "'
,'" . $row['price'] ."'
,'" . $row['total_cost']. "'
,'" . $row['compatibility'] . "'");
mysql_query($order_detail);
}
here you go:
PHP Code:$order_detail="
insert
into
detail_table(
unique_id
, order_id
, customer_name
, customer_login_id
, order_date
, product_name
, quantity
, shipping
, price
, total_cost
, compatibility
) values(
'$unique_id'
, $order_id
, '$username'
, '$log_id'
, '$shop_date'
, '" . $row['product_name'] . "'
, '" . $row['quantity'] . "'
, '" . $row['shipping_cost'] . "'
, '" . $row['price'] ."'
, '" . $row['total_cost']. "'
, '" . $row['compatibility'] . "'
)";
mysql_query($order_detail);
thanks spikez
this works fine now.
vineet
Off Topic:
HI VINEET! *waves* : )
vinpkl, I you haven't already, you might want to take a look at mysql_real_escape_string for data sanitation.
You are welcome :)Quote:
Originally Posted by vinpkl
Definitely worth looking into!Quote:
Originally Posted by ScallioXTX