This is driving me crazy!!! Display prob

tony_l

Below is the entire script- not long at all, but I have a MAJOR PROBLEM when it comes to displaying the information.

This reads of course from a MYSQL database. I know that I have 50 members in the database, BUT it is skipping every other row! So it only displays like 25 people. This page allows me to look at the members at a glance and pick one and it will go directly to an edit page so I can edit their authorizations.

<?php

##############################################

This is the Script for the ACCOUNT ADMIN

##############################################

#######################

Security includes

#######################

include('../ACCESS/tr129.php');
include('../ACCESS/adminsession.php');

################

Start HTML

################

print("<head><title>ACCOUNT ADMIN</title></head><body bgcolor='black' font face='helvetica' font color='white'> ");

################################

Set up database connection

################################

$Link1 = mysql_connect($Host, $User, $Password);

mysql_select_db($DBName, $Link1);

$Query1 = "SELECT* from auth";

$Result1 = mysql_query($Query1, $Link1);

##########################

Loop through results

##########################

while ($row1 = mysql_fetch_array($Result1)) {

print("<a href='http://www.mypage.com/ADMIN/accountadmindisplay.php?$passvar=$row1[auth_id]>$row1[user]</a> ");

}

print("</body>");

majik-sheff

If you check the source from your browser you'll probably see that all of the info is there, just not all of it is being rendered. You're missing a closing quote in your HTML. This would be the way to fix what you have shown:

print("<a href='http://www.mypage.com/ADMIN/accountadmindisplay.php?$passvar=$row1[auth_id]'>$row1[user]</a> ");

Notice the second single quote before the >.

That still shouldn't work, though. You're using associative aray indices which don't work within a quoted set. Here's a line of code that should behave the way you expect it to.

echo("<a href='http://www.mypage.com/ADMIN/accountadmindisplay.php?$passvar=" . $row1["auth_id"] . "'>" . $row1["user"] . "</a> ");

tony_l

Thank you!! That helped me out alot! I was about to go nuts over that.