function get_user($userid) { mysql_query("SELECT name FROM users \n\t WHERE userid = {$userid}"); $userid->name = mysql_fetch(); mysql_query("SELECT key, value \n\t FROM attributes a\n\t\t WHERE userid = {$userid}"); while (list($key, $value) = mysql_fetch()) { $userinfo[$key] = $value; } return $userinfo; }
<?php include 'database.inc'; $res = mysql_query("SELECT\n title, story\n FROM\n news\n LIMIT 1;"); $row = mysql_fetch($res); ?> <h1><?php echo $row['title']; ?> </h1> <p><?php echo $row['story']; ?> </p>