Đã hoàn thành

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

Kĩ năng: MySQL, SQL, PHP, Microsoft SQL Server, Lập trình cơ sở dữ liệu

Về khách hàng:
( 433 nhận xét ) Newport, Australia

ID dự án: #34347731

Được trao cho:

(430 Đánh Giá)

49 freelancer chào giá trung bình$24 cho công việc này

(380 Nhận xét)

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 Thêm

$15 AUD trong 1 ngày
(151 Nhận xét)

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 Thêm

$30 AUD trong 1 ngày
(177 Nhận xét)
(324 Nhận xét)

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

$80 AUD trong 2 ngày
(34 Nhận xét)

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 Thêm

$15 AUD trong 1 ngày
(153 Nhận xét)
(273 Nhận xét)

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] Thêm

$50 AUD trong 1 ngày
(232 Nhận xét)
(85 Nhận xét)

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 Thêm

$30 AUD trong 1 ngày
(52 Nhận xét)
(166 Nhận xét)
(92 Nhận xét)

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 Thêm

$30 AUD trong 1 ngày
(49 Nhận xét)
(28 Nhận xét)

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 trong 1 ngày
(6 Nhận xét)

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 Thêm

$20 AUD trong 1 ngày
(78 Nhận xét)

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 trong 1 ngày
(31 Nhận xét)
(25 Nhận xét)

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 Thêm

$20 AUD trong 1 ngày
(25 Nhận xét)

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 trong 1 ngày
(16 Nhận xét)