Concluído

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

Habilidades: MySQL, SQL, PHP, Microsoft SQL Server , Programação de Banco de Dados

Sobre o Cliente:
( 433 comentários ) Newport, Australia

ID do Projeto: #34347731

Concedido a:

(430 Comentários)
7.8

49 freelancers estão ofertando em média $24 nesse trabalho

(380 Comentários)
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 Mais

$15 AUD em 1 dia
(151 Comentários)
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 Mais

$30 AUD em 1 dia
(177 Comentários)
6.9
(324 Comentários)
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 Mais

$80 AUD in 2 dias
(34 Comentários)
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 Mais

$15 AUD em 1 dia
(153 Comentários)
6.9
(273 Comentários)
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] Mais

$50 AUD em 1 dia
(232 Comentários)
6.6
(85 Comentários)
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 Mais

$30 AUD em 1 dia
(52 Comentários)
5.9
(166 Comentários)
6.1
(92 Comentários)
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 Mais

$30 AUD em 1 dia
(49 Comentários)
5.6
(28 Comentários)
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.

$25 AUD em 1 dia
(6 Comentários)
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 Mais

$20 AUD em 1 dia
(78 Comentários)
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

$19 AUD em 1 dia
(31 Comentários)
4.9
(25 Comentários)
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 Mais

$20 AUD em 1 dia
(25 Comentários)
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

$15 AUD em 1 dia
(16 Comentários)
4.6