foreach vr while

[ptbsG_Man]

im having a problem with these to loops in one case it works but wont work with what i need it t do and the other wont work but i ned it to do the other parts of the page. here that code i have

$data = mssql_fetch_assoc($rs);
foreach ($data as $key=>$value) {
	echo "<a href=\"?id=player&account=$account&playerid=". $data['char_id'] ."\">". $data['char_name'] ."</a><br />";
}

thats what i need to work(so i can grab data out of $data outside a loop but it will only output the first item in the array 2 times, no matter how many return items there are

while ($row = mssql_fetch_assoc($rs)) {
	echo "<a href=\"?id=player&account=$account&playerid=". $row['char_id'] ."\">". $row['char_name'] ."</a><br />";
}

that will output all the items the way i want but i cant just call to the return data outside the loop, the full way it needs to work is like so

$data = mssql_fetch_assoc($rs);
echo "<a href=\"?id=\">Home</a> :: <a href=\"?id=account&account=". $data['account_id'] ."\">". $data['account_name'] ."</a> :: <a href=\"?id=player&account=". $data['account_id'] ."&playerid=". $data['char_id'] ."\">". $data['char_name'] ."</a><br />";
foreach ($data as $key=>$value) {
	echo "<a href=\"?id=player&account=$account&playerid=". $data['char_id'] ."\">". $data['char_name'] ."</a><br />";
}

thanks in advance

[subwayman]

Your use of for each is redunant as you are not using either the $key or $value variables. For each is used to walk through an array NOT a recordset. As such your code and your questio n is confusing enought that we could only guessa t waht you are trying to acheive. So a few questions first:

What columnns are returned in the query?
Give an example of EXACTLY how you want the output to look.

I suspect if you give us this information it will be very easy to tell you how to do what you want.

[ptbsG_Man]

there are aloyt of columnns retured but the ones im working with right now are
char_id, char_name, account_id, account_name

the page has 2 parts right now a navagation bar and then all the character's that the current account has under it so it should look like so

Home :: $account_name

1. char_name
2. char_name
3. ........
   and so on

with char_name linked with char_id like <a href="id=char_id">$char_name</a>. same for $account_name is linked to $account_id

[ptbsG_Man]

ok i got itt working but to make it eayser ill just say that this looks stupid

<?
import_request_variables("g", "uc_");
if (!is_numeric($uc_account)) {
	die("Account should be a number not whatever you have in there.");
}
$account = $uc_account;
$sql = "SELECT char_name, char_id, account_name, account_id FROM [user_data] WHERE account_id=$account";
$rs = mssql_query($sql);
if (mssql_num_rows($rs) < 1) {
	die("There is no such Account on this server!");
}
$data = mssql_fetch_array($rs);
echo "<a href=\"?id=\">Home</a> :: <a href=\"?id=account&account=". $data['account_id'] ."\">". $data['account_name'] ."</a><br /><br />";
mssql_data_seek($rs, 0);
while ($row = mssql_fetch_array($rs)) {
	echo "<a href=\"?id=player&account=$account&playerid=". $row['char_id'] ."\">". $row['char_name'] ."</a><br />";
}
?>

ihave 2 mssql_fetch_array and have to reset trhe pointer for this to work. is there a better way to do this

thanks

[subwayman]

Try this. This will only output the navigation line if it changes as the dataset is looped through. This keeps one loop and no need to reset the pointer.

$currentaccount = 0;
while ($row = mssql_fetch_array($rs)) {
   if ($data['account_id'] != $currentaccount) {
        echo "<a href=\"?id=\">Home</a> :: <a href=\"?id=account&account=". $data['account_id'] ."\">". $data['account_name'] ."</a><br /><br />";
        $currentaccount = $data['account_id'];
   } 
    echo "<a href=\"?id=player&account=$account&playerid=". $row['char_id'] ."\">". $row['char_name'] ."</a><br />"; 
} 

If your data set only returns rows for one account then is can be simplified to:

 

while ($row = mssql_fetch_array($rs)) {
   if (!$navbardone) {
        echo "<a href=\"?id=\">Home</a> :: <a href=\"?id=account&account=". $data['account_id'] ."\">". $data['account_name'] ."</a><br /><br />";
        $$navbardone = true;
   } 
    echo "<a href=\"?id=player&account=$account&playerid=". $row['char_id'] ."\">". $row['char_name'] ."</a><br />"; 
}