<?php
/* CREATE TABLE users (
  userid int not null auto_increment,
  name varchar(128),
  primary key(userid)
);

CREATE TABLE attributes (
  userid int not null,
  key   varchar(128),
  value varchar(128)
);
*/

function get_user($userid) {
	mysql_query("SELECT name FROM users 
	             WHERE userid = $userid");

	$userid->name = mysql_fetch();

	mysql_query("SELECT key, value 
	             FROM attributes a
		         WHERE userid = $userid");

	while(list($key, $value) = mysql_fetch()) {
			$userinfo[$key] = $value;
	}

	return $userinfo;
}
?>