ProdSawax

Thank you so much Guru, I replaced by: $users_info = mysql_query("SELECT users.id, users.username FROM users INNER JOIN confirm ON users.id = confirm.userid WHERE confirm.email = '$email' AND `key` = '$key' LIMIT 1") or die(mysql_error()); with later in code: <?php while($resultat = mysql_fetch_assoc($users_info)) { print_r($resulat); echo $resultat['username']; }?> and that's work ! Have a nice day Guru!

When I tried without the WHERE $users_info = mysql_query("SELECT users.id, users.username FROM users INNER JOIN confirm ON users.id = confirm.userid") or die(mysql_error()); I got this : 'Welcome Resource id #7'

I'm stock at error: Column 'email' in where clause is ambiguous $users_info = mysql_query("SELECT users.id, users.username FROM users INNER JOIN confirm ON users.id = confirm.userid WHERE `email` = '$email' AND `key` = '$key' LIMIT 1") or die(mysql_error());

FYI /When I made: print_r($users_info); I got the error: Resource id #7

My last try (didn't echo any error, but didn't echo the 'username' too) : $users_info = mysql_query("SELECT users.id, users.username FROM users INNER JOIN confirm ON users.id = confirm.userid WHERE users.id = confirm.userid LIMIT 1") or die(mysql_error());

I trying this (without success): $users_info = mysql_query("SELECT users.id, users.username, users.email FROM users INNER JOIN confirm ON users.id = confirm.userid WHERE `email` = '$email' AND `key` = '$key' LIMIT 1") or die(mysql_error());

Thank you Muddy_Funster On progress, only one error: 'Column 'email' in where clause is ambiguous' (and doesn't display "welcome Username")

Precision users.id = confirm.userid : same value I tried also without success: $users_info = mysql_query("SELECT 'username' FROM `users` WHERE `id` = '$confirm_info[userid]' LIMIT 1") or die(mysql_error());

Had tried (doesn't work) this: $users_info = mysql_query("SELECT users.id, users.username, confirm.userid WHERE `$users_info[id]` = '$confirm_info[userid]' LIMIT 1") or die(mysql_error());

Thank you both. I'm newby too. Muddy_Funster had right.In the dB, I'm using these 2 tables: users(id, username, password, email, active) and confirm(id, userid,key,email). When I echo: echo "Welcome '{$confirm_info['userid']}'"; I got well "Welcome 133" and 133 corresponding well to new user. So now, I need to go one step further and to query 'replace {$confirm_info['userid']} by {$users_info['username']} ? In order to get: "welcome UserVerynice" .

Hello, I have download a 'sign up email login form' on the web, the process works (email confirmation), but when after signed i want to echo/print the username I got errors. Here my code (at bellow 'echo 'username'': <?php session_start(); include_once 'inc/php/config.php'; include_once 'inc/php/functions.php'; error_reporting(E_ALL); ini_set( 'display_errors','1'); include 'inc/elements/signed.php'; ?> <?php //setup some variables $action = array(); $action['result'] = null; //check if the $_GET variables are present //quick/simple validation if(empty($_GET['email']) || empty($_GET['key'])){ $action['result'] = 'error'; $action['text'] = 'We are missing variables. Please double check your email.'; } if($action['result'] != 'error'){ //cleanup the variables $email = mysql_real_escape_string($_GET['email']); $key = mysql_real_escape_string($_GET['key']); //check if the key is in the database $check_key = mysql_query("SELECT * FROM `confirm` WHERE `email` = '$email' AND `key` = '$key' LIMIT 1") or die(mysql_error()); if(mysql_num_rows($check_key) != 0){ //get the confirm info $confirm_info = mysql_fetch_assoc($check_key); //confirm the email and update the users database $update_users = mysql_query("UPDATE `users` SET `active` = 1 WHERE `id` = '$confirm_info[userid]' LIMIT 1") or die(mysql_error()); //delete the confirm row $delete = mysql_query("DELETE FROM `confirm` WHERE `id` = '$confirm_info[id]' LIMIT 1") or die(mysql_error()); if($update_users){ $action['result'] = 'success'; $action['text'] = 'User has been confirmed. Thank-You!'; }else{ $action['result'] = 'error'; $action['text'] = 'The user could not be updated Reason: '.mysql_error();; } }else{ $action['result'] = 'error'; $action['text'] = 'The key and email is not in our database.'; } } ?> <?= show_errors($action); ?> <?php include 'hotel/reception.php'; echo "Welcome 'username'"; ?> <?php include 'inc/elements/footer2in.php'; ?>confirm11.phpconfirm11.phpconfirm11.phpconfirm11.php