ta
Posted: Tue Dec 02, 2008 10:22 pm
ta
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$dbname='taniwha_members';
mysql_connect($dbhost, $dbuser, $dbpass)
or die(mysql_error());
mysql_select_db($dbname)
or die(mysql_error());
$query = "SELECT * FROM users";
$num_rows = mysql_num_rows(mysql_query($query));
$query = mysql_query("SELECT * FROM users");
while($db = mysql_fetch_array($query,MYSQL_ASSOC)){
echo "<td><a href='\userinfo.php?user={$db['username']}'>{$db['username']}</a></td>\n";
echo "<td>{$db['fname']}</td>\n";
echo "<td>{$db['lname']}</td>\n";
echo "<td>{$db['age']}</td>\n";
echo "<td>{$db['location']}</td>\n";
echo "<td>{$db['type'].}</td>\n";
echo "<td>{$db['song']}</td>\n";
echo "<tr align=center>\n";
echo "<td><a href=\"userinfo.php?user={$db['username']}\">{$db['username']}</a></td>\n</tr>";
}
?>