xp下php开发环境搭建,Windows XP下PHP+MySQL环境搭建(10)

?>

Username	Full Name	Website

$select = '   SELECT u.username, u.firstname, u.lastname, w.website_url';

$from   = '     FROM users u, user_websites w';

$where  = '    WHERE u.user_id = w.user_id';

$order  = ' ORDER BY u.lastname, u.firstname';

$users = @mysql_query($select . $from . $where . $order);

if (!$users) {

echo('

');

die('

Error retrieving users from database!
'.

'Error: ' . mysql_error() . '

');

}

while ($user = mysql_fetch_array($users)) {

$user_username = htmlspecialchars($user['username']);

$user_firstname = htmlspecialchars($user['firstname']);

$user_lastname = htmlspecialchars($user['lastname']);

$user_website = htmlspecialchars($user['website_url']);

echo("

\n");

echo("

$user_username\n");

echo("

$user_firstname $user_lastname\n");

echo("

$user_website\n");

echo("

\n");

}

?>

mysql_close ($conn);

?>