Member Avatar for niche1

What's the notation to add data from a variable to existing data in a field?


mysql_query("UPDATE stk SET some_field = '????????????' WHERE id = " . $upc_key . "") or die(mysql_error());

  • 2 Contributors
  • 2 Replies
  • 80 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by niche1
Member Avatar for mwasif

Use MySQL's CONCAT() function

To add data at the end of existing

mysql_query("UPDATE stk SET some_field = CONCAT(some_field, '????????????') WHERE id = " . $upc_key . "") or die(mysql_error());

To add data at the start of existing

mysql_query("UPDATE stk SET some_field = CONCAT('????????????',some_field) WHERE id = " . $upc_key . "") or die(mysql_error());
Member Avatar for niche1

That worked. Just needed to escape the double quotes.

Thanks mwasif.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.