Terminé

Help with a simple SQL queries.

I need to add the new Users ID that was added to the database in a email.

The code is already done, I just need someone to make the SQL that gets the last MAX userID form table USERS and adds + 1, and puts that in the line below

$email_message .= "firstname: ".clean_string($_POST['firstname'])."\n";

$email_message .= "lastname: ".clean_string($_POST['lastname'])."\n";

$email_message .= "username: ".clean_string($_POST['username'])."\n";

$email_message .= "email: ".clean_string($_POST['email'])."\n";

$email_message .= "street1: ".clean_string($_POST['street1'])."\n";

$email_message .= "street2: ".clean_string($_POST['street2'])."\n";

$email_message .= "suburb: ".clean_string($_POST['suburb'])."\n";

$email_message .= "state: ".clean_string($_POST['state'])."\n";

$email_message .= "postcode: ".clean_string($_POST['postcode'])."\n";

$email_message .= "country: ".clean_string($_POST['country'])."\n";

+++=========================== NEED TO ADD THE BELOW ====

$email_message .= "userid: ".clean_string($_POST['userid'])."\n";

[ADD the new "userid" to email here] Eg Get MAX userID from table "userid" and add +1]

+++===========================

Mention Clear in comments of your bid will be ignored, should be a quick job, I will provide php page

Compétences : MySQL, SQL, PHP, Serveur SQL Microsoft, Programmation de bases de données

Concernant le client :
( 433 commentaires ) Newport, Australia

Nº du projet : #34347731

Décerné à:

(430 Commentaires)
7.8

49 freelances font une offre moyenne de 24 $ pour ce travail

(380 Commentaires)
7.9
wmkosc

I have been website developer for over 7 years and have much experience in this field. I read your requirement and really interested, I can start working immediately, I am sure I can add that userid fast and make it wo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(151 Commentaires)
6.9
imTuyen

Hi Chris. I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. P Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(177 Commentaires)
6.9
(324 Commentaires)
6.7
maxpl

Hi, I hope all is well there. I am an experienced web and mobile app developer. I have 8+ years of experienc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(34 Commentaires)
6.8
creativeitechpvt

Hello, I have reviewed your requirements, and I believe that with my experience and skills, I can deliver to you as per your expectation. i have been working with USA base company, onwards i'm available full time for Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(153 Commentaires)
6.9
(273 Commentaires)
7.1
bestphpjobs

Hi I am ready to start right now I have read your project very carefully I have almost done many work like this. I am very confident about this job Please check following link to see my work [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(232 Commentaires)
6.6
(85 Commentaires)
6.0
vinhtq0703

Hi I have 8+ years of experience as a programmer with PHP, Laravel, Wordpress, ReactJs, VueJS, ... I can build a complete website system with many functions perfectly. I have read your project description clearly and I Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(52 Commentaires)
5.9
(166 Commentaires)
6.1
(92 Commentaires)
5.8
psharma3368

Hello sir I can add sql query in php page to get max user id from database table and add +1 then set in email messages. I need to discuss on max id because in your case there id possibility that 2 users can get same u Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(49 Commentaires)
5.6
(28 Commentaires)
5.6
nikil02an

Hi, I can write query for the same and get the recent email address, update the counter field value as per your requirement. Looking forward to hearing from you soon. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(6 Commentaires)
5.4
gustavofulanetto

Hi, From what I understand, you want the last register from the table "users" to be picked, want 1 to be summed to its value and then want the value of the sum to be passed to a variable and the variable value should Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(78 Commentaires)
5.0
namembk

Hi, I can add user in your code with ease as I got over 6 years of experience in building websites. Ping me to discuss further Thanks Best Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(31 Commentaires)
4.9
(25 Commentaires)
5.1
hoaxuyentri

Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuy Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(25 Commentaires)
4.5
NagarajTN

Hello Client i can do this work,i am ready to start work now,i can provide best quality work,please chat now

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(16 Commentaires)
4.6