hi
i have this code
But $row["A"] and $row["B"] etc gives an database output 1 or 0
How can i change this in X or 0
$connection = mssql_connect($db_hostname, $db_username, $db_password);
$db = mssql_select_db($db_name, $connection);
$sql = "EXEC spITCOKruisjesLijst $ID";
echo '
<center>
<table border=1 width=100%>
<tr>
<td><p align=center><b>Naam</B></td>
<td><p align=center><b>Afdeling</B></td>
<td><p align=center><b>Rol</B></td>
<td><p align=center><b>Telefoonnummer</B></td>
<td><p align=center><b>A</B></td>
<td><p align=center><b>B</B></td>
<td><p align=center><b>C</B></td>
<td><p align=center><b>D</B></td>
<td><p align=center><b>E</B></td>
<td><p align=center><b>F</B></td>
<td><p align=center><b>G</B></td>
<td><p align=center><b>H</B></td>
<td><p align=center><b>I</B></td>
<td><p align=center><b>J</B></td>
<td><p align=center><b>K</B></td>
</tr>';
$result = mssql_query($sql,$connection);
while ($row = mssql_fetch_array($result))
{
echo '
<tr>
<td><p align=center>'.$row["strName"].'</td>
<td><p align=center>'.$row["strFullAbbr"].'</td>
<td><p align=center>'.$row["strType"].'</td>
<td><p align=center>'.$row["strTelNr"].'</td>
<td><p align=center>'.$row["A"].'</td>
<td><p align=center>'.$row["B"].'</td>
<td><p align=center>'.$row["C"].'</td>
<td><p align=center>'.$row["D"].'</td>
<td><p align=center>'.$row["E"].'</td>
<td><p align=center>'.$row["F"].'</td>
<td><p align=center>'.$row["G"].'</td>
<td><p align=center>'.$row["H"].'</td>
<td><p align=center>'.$row["I"].'</td>
<td><p align=center>'.$row["J"].'</td>
<td><p align=center>'.$row["K"].'</td>
</tr>';
}
echo '</table>';
