ta

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
siffin
Forum Newbie
Posts: 2
Joined: Tue Dec 02, 2008 10:08 pm

ta

Post by siffin »

ta
Last edited by siffin on Sat Jan 03, 2009 2:43 am, edited 1 time in total.
mikelbring
Forum Commoner
Posts: 38
Joined: Sat Jan 05, 2008 5:28 pm

Re: help needed

Post 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>";
    
}
?>
Post Reply