Page 1 of 1

ta

Posted: Tue Dec 02, 2008 10:22 pm
by siffin
ta

Re: help needed

Posted: Tue Dec 02, 2008 10:58 pm
by mikelbring
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>";
    
}
?>