The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
I try to change the first 0 on a phone number to replace by +33 (french indicator).
I change this with a SQL request:
UPDATE wp_si_connections_phone SET number = CONCAT("+33",RIGHT(number,9)) WHERE number like "0%"
But, I have to change these numbers on
wp_si_connections table in
How can I do that?
Do you have another way to update all my database with this indicator?
You’ve have to create a PHP function to do this.
You would the wpdb API to select the phone_numbers field from the primary table.
Then you would loop thru the results unserializing the array data, performing the PHP equivalent of CONCAT, serialize the array and update the row in the database.
Hope this helps!
You cannot reply to this support topic. Please open your own support topic.