Code: Select all
$user_id = (isset($_GET['id'])) ? $_GET['id'] : '';
$last_name = (isset($_GET['name'])) ? $_GET['name'] : '';
$query = 'SELECT
username, first_name, last_name, email, company, user_type
FROM
site_user u JOIN site_user_info i ON u.user_id = i.user_id
WHERE
u.user_id = ' . $user_id . '
AND
last_name = ' . $last_name;
$result = mysql_query($query, $db) or die(mysql_error($db));