MSSQL Select column from table

[da_unknown]

Hi ,
i have a little problem with mssql , cuz i wanted read out some columns to show in a table with php.
My Question is how i can make a row of the dataset.
I tried it but i see only the same in the table not the next entries of the column.

here a part of the code:

echo "<center><table border='1'><tr>
	        <td align='center'><font color='#FFFFFF'>Char_no</font></td>
		<td align='center'><font color='#FFFFFF'>wIndex</font></td>
		<td align='center'><font color='#FFFFFF'>Header</font></td>
		<td align='center'><font color='#FFFFFF'>line_no</font></td>
		
	</tr>";


$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Connection lost,try it again later.");

$result1 = mssql_query("SELECT character_no FROM character.dbo.user_bag WHERE character_no = 'A09050520000000021'",$con);


while($row1 = mssql_fetch_row($result1)) {
	
	$result2 = mssql_query("SELECT character_no,wIndex,byHeader,line_no FROM character.dbo.user_bag WHERE character_no = 'A09050520000000021' ORDER by line_no DESC",$con);
	$row2 = mssql_fetch_row($result2);

	{

echo "<tr>
<td align='center'><font color='#FFFFFF' size='3' >".$row2[0]."</font></td>
<td align='center'><font color='#FFFFFF' size='3' >".$row2[1]."</font></td>
<td align='center'><font color='#FFFFFF' size='3' >".$row2[2]."</font></td>
<td align='center'><font color='#FFFFFF' size='3' >".$row2[3]."</font></td>
			
		</tr>";

	}

}

echo "</table></center>";

--------------------------------------------------------------
My Results are like this

Char_no wIndex byHeader line_no
1 9901 1 1
1 9901 1 1
1 9901 1 1

Just the same item
it must looks like this that i see all items from a character for example

Char_no wIndex byHeader line_no
1 9901 1 1
1 9902 5 16
1 9903 8 24

I hope anyone can help.

Greetings
dA-uNknOwN

[Zombe]

I use my cleaned database, so I don't rly have any characters or items, but try this:

PHP Code:

<?php
echo ("
    <center>
        <table border='1'>
            <tr>
                <td align='center'><font color='#FFFFFF'>Char_no</font></td>
                <td align='center'><font color='#FFFFFF'>wIndex</font></td>
                <td align='center'><font color='#FFFFFF'>Header</font></td>
                <td align='center'><font color='#FFFFFF'>line_no</font></td>    
            </tr>
");
$con = mssql_connect('host','user','password') or die("Couldn't connect to the database.");
$result = mssql_query("SELECT character_no FROM character.dbo.user_bag WHERE character_no = 'A09050520000000021'",$con);
while($array = mssql_fetch_row($result))
{
    $result2 = mssql_query("SELECT character_no,wIndex,byHeader,line_no FROM character.dbo.user_bag WHERE character_no = 'A09050520000000021' ORDER by line_no DESC",$con);
    while($array2 = mssql_fetch_row($result2));
    {
        echo ("<tr>");
        foreach($array2 as $row) echo("<td align='center'><font color='#FFFFFF' size='3' >$row</font></td>");
        echo("</tr>");
    }
}
echo ("
        </table>
    </center>"
);
?>

Give it a try.

[pieter]

of all else fails u can always go DISTINCT

but zombe's sollution should work

[da_unknown]

Hi Zombe,
Thanks for your anwser your code looks easier and cleaner.
I got an error with this foreach invalid argument i added before foreach

$array2 = array();

and the error is away but it gives me no results
with

array(1, 2, 3, 4);

i see an empty table.

The solution is near but .. i send you a pm with a testlogin to my database eventually you have time for a new idea

Greetings
dA-uNknOwN