ta
Moderator: General Moderators
-
mikelbring
- Forum Commoner
- Posts: 38
- Joined: Sat Jan 05, 2008 5:28 pm
Re: help needed
I rewrote some of your code because it was completely messed up. I don't understand your html so I did whatever. Try this:
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>";
}
?>