I'm facing this problem in PHP

Hello dex members,
you've been great help to me ,and i'm hopeing to find the answer to my
problem here .
i'm creating this php loop to build a site map each level of this loop
have font but when i run this code it only reads the font size and
doen't read the color.this is the code please read it and help me to
find what's wrong.


<?
require_once('odbc.php');
$query = odbc_exec($odbc, "select * from SiteCell") or die
(odbc_errormsg());
while ($row = odbc_fetch_array($query))
{
echo "<br>";

if ($row['Cell_Pos'] == "1")
{
echo "<B><font size='4' color='75750F'>";
echo "<img src='usm.gif' >";

if ($row['flag_value'] == "Acml")
{
echo "<a href='".$row['Url']."'>";
echo $row['Cell_Name'].'</a><br/>';
echo"</font></b>";
}
else
{
echo $row['Cell_Name'].'<br/>';
echo"</font></b>";
}
}
elseif ($row['Cell_Pos'] == "2")
{
echo "<i><font size='4' color='008000'>";
echo      ";
echo "<img src='dsmh.gif' >";
if ($row['flag_value'] =="Acml")
{
echo "<a href='".$row['Url']."'>";
echo $row['Cell_Name'].'</a><br/>';
echo"</font></b>";
}
else
{
echo $row['Cell_Name'].'<br/>';
echo"</font></i>";
}
}
elseif ($row['Cell_Pos'] == "3")
{
echo "      ";
echo "<font size='3' color='CD6740'>";
if ($row['flag_value'] =="Acml")
{
echo "<a href='".$row['Url']."'>";
echo $row['Cell_Name'].'</a><br/>';
echo"</font></b>";
}
else
{
echo $row['Cell_Name'].'<br/>';
echo"</font>";

}

}
elseif ($row['Cell_Pos'] == "4")
{
echo "       ";
echo "<font size='3' color='CD6740'>";
if ($row['flag_value'] =="Acml")
{
echo "<a href='".$row['Url']."'>";
echo $row['Cell_Name'].'</a><br/>';
echo"</font></b>";
}
else
{
echo $row['Cell_Name'].'<br/>';
echo"</font>";
}

}

}
odbc_close ($odbc);

?>
Best regars
Yoya ali

*** Sent via Developersdex http://www.developersdex.com ***
developers [ Mo, 21 November 2005 13:32 ] [ ID #1067419 ]

Re: I'm facing this problem in PHP

echo "<B><font size='4' color='#75750F'>";

Bob Lehmann

<developers> wrote in message news:ued3iep7FHA.3804 [at] TK2MSFTNGP14.phx.gbl...
>
>
> Hello dex members,
> you've been great help to me ,and i'm hopeing to find the answer to my
> problem here .
> i'm creating this php loop to build a site map each level of this loop
> have font but when i run this code it only reads the font size and
> doen't read the color.this is the code please read it and help me to
> find what's wrong.
>
>
> <?
> require_once('odbc.php');
> $query = odbc_exec($odbc, "select * from SiteCell") or die
> (odbc_errormsg());
> while ($row = odbc_fetch_array($query))
> {
> echo "<br>";
>
> if ($row['Cell_Pos'] == "1")
> {
> echo "<B><font size='4' color='75750F'>";
> echo "<img src='usm.gif' >";
>
> if ($row['flag_value'] == "Acml")
> {
> echo "<a href='".$row['Url']."'>";
> echo $row['Cell_Name'].'</a><br/>';
> echo"</font></b>";
> }
> else
> {
> echo $row['Cell_Name'].'<br/>';
> echo"</font></b>";
> }
> }
> elseif ($row['Cell_Pos'] == "2")
> {
> echo "<i><font size='4' color='008000'>";
> echo      ";
> echo "<img src='dsmh.gif' >";
> if ($row['flag_value'] =="Acml")
> {
> echo "<a href='".$row['Url']."'>";
> echo $row['Cell_Name'].'</a><br/>';
> echo"</font></b>";
> }
> else
> {
> echo $row['Cell_Name'].'<br/>';
> echo"</font></i>";
> }
> }
> elseif ($row['Cell_Pos'] == "3")
> {
> echo "      ";
> echo "<font size='3' color='CD6740'>";
> if ($row['flag_value'] =="Acml")
> {
> echo "<a href='".$row['Url']."'>";
> echo $row['Cell_Name'].'</a><br/>';
> echo"</font></b>";
> }
> else
> {
> echo $row['Cell_Name'].'<br/>';
> echo"</font>";
>
> }
>
> }
> elseif ($row['Cell_Pos'] == "4")
> {
> echo "       ";
> echo "<font size='3' color='CD6740'>";
> if ($row['flag_value'] =="Acml")
> {
> echo "<a href='".$row['Url']."'>";
> echo $row['Cell_Name'].'</a><br/>';
> echo"</font></b>";
> }
> else
> {
> echo $row['Cell_Name'].'<br/>';
> echo"</font>";
> }
>
> }
>
> }
> odbc_close ($odbc);
>
> ?>
> Best regars
> Yoya ali
>
> *** Sent via Developersdex http://www.developersdex.com ***
Bob Lehmann [ Mo, 21 November 2005 14:36 ] [ ID #1067421 ]

Re: I'm facing this problem in PHP

Thank you for replying ,
But the problem is the same , I used the(#)sign But it didn't work .
Thank you any way .
Best regards,
Yoya Ali

*** Sent via Developersdex http://www.developersdex.com ***
developers [ Mi, 23 November 2005 12:31 ] [ ID #1070667 ]
Webserver » microsoft.public.inetserver.asp.db » I'm facing this problem in PHP

Vorheriges Thema: Query an XML file like a recordset?
Nächstes Thema: delete related records