Just for example, try something like:
Code:
$sql = "SELECT m.userame, p.fullname
FROM members AS m, members_profile_info AS p
WHERE m.username = p.username
AND m.username = '$uname'";
$getinfo = mysql_query( $sql ) or die( mysql_error );
$userinfo = mysql_fetch_array($getinfo);
echo 'Welcome ' . $userinfo['username'] . '!';
echo '<br/>Fullname:' . $userinfo['fullname'];
...
If you need other fields from the two tables, LIST THEM EXPLICITLY in your SELECT statement. DO *NOT* USE
select * if at all possible.