Terminé

SQL query select rename multiple choice in php file

I am looking to rename multiple choice answers client side (php file) that are showing as numbers.

Example what I now have in my PHP file:

'sql_query' => "SELECT element_10,element_2,element_3,element_5,element_4,element_6,element_8,element_9 FROM ap_form",

Here's what I need

element_5 has 2 choices

Choice 1 is showing up 1 I would like it to be MA

Choice 2 is showing up 2 I would like it to be NH

element_9 has 3 choices

Choice 1 is showing up 1 I would like it to be <i class="fa fa-check" aria-hidden="true"></i>

Choice 2 is showing up 2 I would like it to be <i class="fa fa-times" aria-hidden="true"></i>

Choice 2 is showing up 3 I would like it to be <i class="fa fa-clock-o" aria-hidden="true"></i>

element_6 is a phone number I would like formatted also

it is now a 10 digit phone XXXXXXXXXX, if possible I would like it to format to XXX-XXX-XXXX

Compétences : HTML, Javascript, MySQL, PHP, SQL

en voir plus : as in select query, sql alias join, sql rename column in query results, assigning result set column names, sql from multiple tables, changing column names in sql query results, sql rename column in select, sql alias, multiple choice test php, php create multiple choice website, php codes multiple choice quiz, need testing written php multiple choice, staff testing tools login php multiple choice, multiple choice picture php, multiple choice php, upload rename multiple pictures php, upload resize rename multiple images php, create multiple choice php, random question multiple choice php, adobe flash cs4 multiple choice sample file

Concernant l'employeur :
( 2 commentaires ) Nashua, United States

Nº du projet : #17612649

Décerné à:

abhi98041

I am a SQL expert and I can do your job. I have more than 7 years of experience in this field. I can start immediately and can complete it. Please check my reviews in https://www.freelancer.com/u/abhi98041 and please m Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(129 Commentaires)
5.7

10 freelance font une offre moyenne de $25 pour ce travail

MrDakaration

Hi I’m an expert in this field and I can get this done for you starting right away no problem. Please let us discuss more in chat so we can get this professionally done.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
5.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(19 Commentaires)
4.6
kcgzerone520

Hey, I can filter the sql as you want and it will take about a couple of hours. Please let me check your current database structure. Thanks, Alex.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
3.8
kunalnt

I have 8+ years in web designing & development with good experience in following skills ... 1. HTML5 2. CSS,CSS 3 & LESS 3. JS (Angular JS, Backbone JS,React JS, node.js, expresss JS, Gulf JS) 4. Java Script & Jq Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)
3.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.2
seabdulbasit

Hello Sir I have been working on different projects on android and websites, besides these I have good experience working with Graphics, I can work professionally for you on this project. I hope you will not be disa Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
2.8
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
evonsystems7

Hi there, I am a fulltime freelance web & mobile app developer. I got lot of experience on both web & mobile app development, Good with HTML, CSS, JS for frontend website Love coding with PHP and MySQL as datab Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.0
thebubbles

It seems like a small change, but may you provide the DataBase engine you are using, and php version? thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0