Simple Problem with a list...

tony_l

I am going nuts here trying to figure out exactly what I am doing wrong. I have pasted the query into phpmyadmin and it gives me the desired results. but when I upload the script it does not list anything. Also- I know that the results are going through becasue i have a count variable that is listing the correct count that is in the database. Any suggestions?

INCLUDE("header.php");
INCLUDE("INCLUDES/new_vars.php");

#########################
## Connect to Database ##
#########################

$link = mysql_connect($db_host, $db_user, $db_pass) or die("Sorry, the Database is Not Available at this time.");

mysql_select_db($dbn, $link);


#####################
## Get Information ##
#####################

$Query = "SELECT phpbb_users.user_char_name, phpbb_users.username, phpbb_users.user_regdate FROM phpbb_users, phpbb_user_group WHERE phpbb_users.user_id = phpbb_user_group.user_id AND phpbb_user_group.group_id = '416'";
$Results = mysql_query($Query, $link);
$count = mysql_num_rows($Results);

#################
## Set up page ##
#################

PRINT("

<center>
<span class='infoHeader1'>
MEMBERS LIST
</span>
<br><br>
<span class = 'adminHeader3'>Number of ACTIVE Members: </span><span class='sysMsgBad'>$count</span>
<br><br>

<table width ='85%'>

<tr>
	<td>&nbsp;</td>
	<td><span class = 'text'><b>Character Name</b></span></td>
	<td><span class = 'text'><b>Member Name<br>(Forum Name)</b></span></td>
	<td><span class = 'text'><b>Join Date</b></span></td>
	<td><span class = 'text'><b>Position</b></span></td>
	<td><span class = 'text'><b>Rank<b/></span></td>
</tr>

");

##########################
## Loop Through Results ##
##########################

WHILE($row = mysql_fetch_array($Results));
{

$join = date("M j, Y",$row[2]);

PRINT("

<tr>
	<td></td>
	<td><span class = 'purpleTextBold'>$row[user_char_name]</span></td>
	<td><span class = 'greenTextBold'>$row[username]</span></td>
	<td><span class = 'text'>$join</span></td>
	<td><span class = 'redTextBold'>&nbsp;</span></td>
	<td><span class = 'redTextBold'>&nbsp;</span></td>
</tr>


");


}

PRINT("</table></center>");

INCLUDE("footer.php");

?>

I should also say that the page gives NO ERROR!

trooper

you are using an associative array rather than an indexed one so when you print out the $row value it should be like this

 <td><span class = 'greenTextBold'>$row['username']</span></td>

note that its $row['columnname']

HTH

tony_l

That did not help at all, that just gives me a t-string expected error.

Is there anyone that knows what i am doing wrong- I have been programming in PHP for 2 years now and I THOUGHT had this down. I have done this sort of thing for a long time. The Results IS WORKING, somehow though, the rest has ceased to function.

Someone please help me- this is very disheartening to me.