Making only selected "cell" bold

If flag is 1 then previous CELL should be bold?

[shruti]

My challenge here is that if dropflag is 1 ( its boolean) then the previous cell of Drps should be bold......!?

Similarly, if trafflag is 1 then previous cell (NOT ROW, NOT COLUMN) should be bold.

And thus for ihfflag and tchaflag.

Note: I don't display the flags on the webpage.
==========================================================

My data base table XYZ is

BSCID, Cellid , Seiz , Drps ,dropflag ,RF, Oth ,Traff, trafflag , Total , DIT , IHFL ,ihfflag , TCD , TCA ,SDD , SDA ,TAVL ,tchaflag , Drate ,date .
===========================================================

MY PHP code to display :

<?php
$host = "localhost";
$user = "";
$pass = "";
$dbname = "";

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . mysql_error());
$db_selected = mysql_select_db('tmetrix', $connection);

$dt= DATE('Y-m-d');
$data = mysql_query("SELECT * FROM XYZ where date = '$dt'")
or die(mysql_error());
Print "<table border=0 cellspacing=0 cellpadding=0 width=800 style='width:725.75pt'>";


$info= mysql_query($query);
$num_data = mysql_num_rows($data);

for ($i=0; $i <$num_data; $i++)
{

$row = mysql_fetch_array($data);

if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}

echo "<td style='text-align:left'>" .$row['BSCID'] . "</td> ";
echo "<td style='text-align:left'>" .$row['Cellid'] . "</td> ";
echo "<td>" .$row['Seiz'] . "</td> ";
echo "<td>" .$row['Drps'] . "</td> ";
echo "<td>" .$row['Total'] ." </td> ";
echo "<td>" .$row['Dlta'] . "</td> ";
echo "<td>" .$row['RF'] . "</td> ";
echo "<td>" .$row['Oth'] . "</td> ";
echo "<td>" .$row['Traff'] . "</td> ";
echo "<td>" .$row['IHFL'] . "</td> ";
echo "<td>" .$row['TCD'] . "</td> ";
echo "<td>" .$row['TCA'] . "</td> ";
echo "<td>" .$row['SDD'] . "</td> ";
echo "<td>" .$row['SDA'] . "</td> ";
echo "<td>" .$row['TAVL'] . "</td> ";
echo "<td>" .$row['Drate'] . "</td>";

?>

[shruti]

Please help me ! I have tired few " FOR LOOP " and "IF LOOP"........
IT screws up the whole code.
So please help.

[cameraman]

Since it's the previous cell then you can't echo it straight out. I would put them into an array and echo them all after the data has all been extracted from the table. Personally I'd use CSS classes but in keeping with your inline style:
for($i=0; $i < $num_data; $i++) {
$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
$rows[$i]['Drps'] = "<td>" . $row['Drps'] . "</td>";
.
.
if($row['dropflag'])
$rows[$i-1]['Drps'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['Drps']);
}

for($i=0; $i < $num_data; $i++) {
if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}
foreach($rows[$i] as $cell)
echo $cell;
}

[shruti]

[b]Thank you cameraman for your reply. But I just few lines on the browser.

May be I am making a mistake or is it something else? Please help me again!
I edited my code to the following:

<?php
$host = "localhost";
$user = "";
$pass = "";
$dbname = "";

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . mysql_error());
$db_selected = mysql_select_db('tmetrix', $connection);

$dt= DATE('Y-m-d');
$data = mysql_query("SELECT * FROM XYZ where date = '$dt'")
or die(mysql_error());
Print "<table border=0 cellspacing=0 cellpadding=0 width=800 style='width:725.75pt'>";

$info= mysql_query($query);
$num_data = mysql_num_rows($data);

for($i=0; $i < $num_data; $i++) {
$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
$rows[$i]['Drps'] = "<td>" . $row['Drps'] . "</td>";
$rows[$i]['Total'] = "<td>" . $row['Total'] . "</td>";
$rows[$i]['Dlta'] = "<td>" . $row['Dlta'] . "</td>";
$rows[$i]['RF'] = "<td>" . $row['RF'] . "</td>";
$rows[$i]['Oth'] = "<td>" . $row['Oth'] . "</td>";
$rows[$i]['Traff'] = "<td>" . $row['Traff'] . "</td>";
$rows[$i]['IHFL'] = "<td>" . $row['IHFL'] . "</td>";
$rows[$i]['TCD'] = "<td>" . $row['TCD'] . "</td>";
$rows[$i]['TCA'] = "<td>" . $row['TCA'] . "</td>";
$rows[$i]['SDD'] = "<td>" . $row['SDD'] . "</td>";
$rows[$i]['SDA'] = "<td>" . $row['SDA'] . "</td>";
$rows[$i]['TAVL'] = "<td>" . $row['TAVL'] . "</td>";
$rows[$i]['Drate'] = "<td>" . $row['Drate'] . "</td>";

if($row['dropflag'])
$rows[$i-1]['Drps'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['Drps']);
}

for($i=0; $i < $num_data; $i++) {
if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}
foreach($rows[$i] as $cell)
echo $cell;
}

?>

[cameraman]

I forgot the line that fetches the data - you still need that:
for($i=0; $i < $num_data; $i++) {
$row = mysql_fetch_array($data);
$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
.
.

[shruti]

Thanks again...........But it does not work!
:(( Sad

<?php

$host = "localhost";
$user = "";
$pass = "";
$dbname = "";

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL

server: " . mysql_error());
$db_selected = mysql_select_db('', $connection);

$dt= DATE('Y-m-d');
$data = mysql_query("SELECT * FROM #*$! where date = '$dt'")
or die(mysql_error());
Print "<table border=0 cellspacing=0 cellpadding=0 width=800 style='width:725.75pt'>";

$info= mysql_query($query);
$num_data = mysql_num_rows($data);

for($i=0; $i < $num_data; $i++) {

$row = mysql_fetch_array($data);

$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
$rows[$i]['Drps'] = "<td>" . $row['Drps'] . "</td>";
$rows[$i]['Total'] = "<td>" . $row['Total'] . "</td>";
$rows[$i]['Dlta'] = "<td>" . $row['Dlta'] . "</td>";
$rows[$i]['RF'] = "<td>" . $row['RF'] . "</td>";
$rows[$i]['Oth'] = "<td>" . $row['Oth'] . "</td>";
$rows[$i]['Traff'] = "<td>" . $row['Traff'] . "</td>";
$rows[$i]['IHFL'] = "<td>" . $row['IHFL'] . "</td>";
$rows[$i]['TCD'] = "<td>" . $row['TCD'] . "</td>";
$rows[$i]['TCA'] = "<td>" . $row['TCA'] . "</td>";
$rows[$i]['SDD'] = "<td>" . $row['SDD'] . "</td>";
$rows[$i]['SDA'] = "<td>" . $row['SDA'] . "</td>";
$rows[$i]['TAVL'] = "<td>" . $row['TAVL'] . "</td>";
$rows[$i]['Drate'] = "<td>" . $row['Drate'] . "</td>";

if($row['dropflag'])
$rows[$i-1]['Drps'] = str_replace('<td>','<td

style="font-weight:bold">',$rows[$i-1]['Drps']);
}

for($i=0; $i < $num_data; $i++) {
if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}
foreach($rows[$i] as $cell)
echo $cell;
}

[shruti]

Well here is the revised version which does bold but bolds the wrong rows and misses few ones.!

Am I making any mistake?

....
.
.
.
.
.
.
.
.
or die(mysql_error());
Print "<table border=0 cellspacing=0 cellpadding=0 width=800 style='width:725.75pt'>";

$info= mysql_query($query);
$num_data = mysql_num_rows($data);

for($i=0; $i < $num_data; $i++) {

$row = mysql_fetch_array($data);

$rows[$i]['BSCID'] = "<td>" . $row['BSCID'] . "</td>";

$rows[$i]['Cellid'] = "<td>" . $row['Cellid'] . "</td>";

$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
$rows[$i]['Drps'] = "<td>" . $row['Drps'] . "</td>";
$rows[$i]['RF'] = "<td>" . $row['RF'] . "</td>";
$rows[$i]['Oth'] = "<td>" . $row['Oth'] . "</td>";
$rows[$i]['Traff'] = "<td>" . $row['Traff'] . "</td>";
$rows[$i]['Total'] = "<td>" . $row['Total'] . "</td>";

$rows[$i]['DIT'] = "<td>" . $row['DIT'] . "</td>";

$rows[$i]['IHFL'] = "<td>" . $row['IHFL'] . "</td>";
$rows[$i]['TCD'] = "<td>" . $row['TCD'] . "</td>";
$rows[$i]['TCA'] = "<td>" . $row['TCA'] . "</td>";
$rows[$i]['SDD'] = "<td>" . $row['SDD'] . "</td>";
$rows[$i]['SDA'] = "<td>" . $row['SDA'] . "</td>";
$rows[$i]['TAVL'] = "<td>" . $row['TAVL'] . "</td>";
$rows[$i]['Drate'] = "<td>" . $row['Drate'] . "</td>";

if($row['dropflag'])
$rows[$i-1]['Drps'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['Drps']);

if($row['trafflag'])
$rows[$i-1]['Traff'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['Traff']);

if($row['ihfflag'])
$rows[$i-1]['IHFL'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['IHFL']);

if($row['tchaflag'])
$rows[$i-1]['TAVL'] = str_replace('<td>','<td style="font-weight:bold">',$rows[$i-1]['TAVL']);

}

for($i=0; $i < $num_data; $i++) {
if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}
foreach($rows[$i] as $cell)
echo $cell;
}

?>

[cameraman]

The only thing I see wrong is there's no ending </TR>. You need to end the row after each set of <td>s.
When you say "bolds the wrong rows" what exactly do you mean - did I misunderstand your original post? The way I understood your original post is that if a flag is set, you want the corresponding cell in the previous row to be bold; this script should be doing that.