change post author color

[christa]

hi all, in my blog (made by me, no wordpress or similar) i would want to change the color of comments written by author of article

My code is:

$sql = "SELECT author WHERE art_id=...";

//print all comments...
while ($row = mysql_fetch_array($result)) {
if ($_SESSION['ID_user'] == $sql['ID_user'] ) {
$color = "#FFFFFF";
} else {
$color = "#FF0000";
}

echo '<div id="comment" style="background-color: ' . $color . '">post</div>';
}

but the code above print all FFFFFF or all FF0000

 

Where it is wrong? thanks

[Pikachu2000]

I believe that $sql['ID_user'] is undefined. It should be $row['ID_user'], no?

[christa]

here the complete code:

//print all comments...
while ($row = mysql_fetch_array($result)) {

$sql_user = mysql_query("SELECT u.IDuser FROM users u JOIN articles a ON a.IDuser=u.IDuser AND a.IDart=$_GET['IDart'] WHERE u.IDuser=" . $_SESSION['IDuser'] . "");
$row2 = mysql_fetch_array($sql_user);
   if ($_SESSION['IDuser'] == $row2['IDuser'] ) {
      $color = "#FFFFFF";
   } else {
      $color = "#FF0000";
   }
echo '<div id="comment" style="background-color: ' . $color . '">post</div>';
}

[Pikachu2000]

That isn't the same code that's in your first post. Which one is the code that's actually being used? Without the actual code that's causing the actual problem, there's no point even looking at it.

[PFMaBiSmAd]

There's also no point in executing the same exact query over and over inside of a loop. The result will be exactly the same each time the query is executed.

[christa]

the actual code is my second.

 

 

[christa]

some suggests?

[BlueSkyIS]

is this ever true? echo the values and see.

 

$_SESSION['IDuser'] == $row2['IDuser']

[christa]

yes, the 2 values are comparated and matched when the user is logged and he is the author of the article

[BlueSkyIS]

so, are the conditions ALWAYS true?

 

-----> echo the values and see. <-----