PHP - Clean Alternative To Mysql_query('...')or Trigger_error(mysql_error(),256);

can someone enlighten me as to what is wrong with this snippet
Code: [Select]
$message_sql = "select * from messages where to_id=$id and read='no'";
$message_query = mysql_query($message_sql);
$message_num_rows = mysql_num_rows($message_query);

i get this error
Code: [Select]
PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given
what its basically telling me is that the "read" filed doesnt exist..because when I take it out of my query, the query works fine...however I do have a "read" field in my db with  value of "no" stored in it..so im not sure why its telling me that it doesnt exist..

Hello friends

if i've this

$text = "i love adult sites"

then i wanna clean it by elminate words like
adult - bad - kill - die
so it be

$clean = "i love sites"

as you can see it eliminated the word adult

how it could be which code can i use ?

thanks in advance

What is the cleanest way to write this if?

Code: [Select]
<div <?php if (!empty($otherfans)) {echo "class=\"newstext\"";} else {echo "class=\"newstext pts\""; } ?>>

Hi,

Here is a tiny bit of my code


$r = mysql_query ($query);

while ($row = mysql_fetch_array ($r, MYSQL_ASSOC)) {
 


echo "<tr>

<td align=\"center\">";  echo date("M-d-Y", mktime(0, 0, 0, $row['month'], $row['day'], $row['year'])); echo "</td> ";

    if ($row['presenter1status'] == '0')
              {
              echo "<td align=\"center\"><font color=\"#FF9900\">{$row['presenter1']}</font></td>";
              }
          elseif ($row['presenter1status'] == '1')
              {
              echo "<td align=\"center\"><font color=\"green\">{$row['presenter1']}</font></td>";
              }
          elseif ($row['presenter1status'] == '2')
              {
              echo "<td align=\"center\"><font color=\"red\">{$row['presenter1']}</font></td>";
              }


    if ($row['presenter2status'] == '0')
              {
              echo "<td align=\"center\"><font color=\"#FF9900\">{$row['presenter2']}</font></td>";
              }
          elseif ($row['presenter2status'] == '1')
              {
              echo "<td align=\"center\"><font color=\"green\">{$row['presenter2']}</font></td>";
              }
          elseif ($row['presenter2status'] == '2')
              {
              echo "<td align=\"center\"><font color=\"red\">{$row['presenter2']}</font></td>";
              }
            
            
             if ($row['engineerstatus'] == '0')
              {
              echo "<td align=\"center\"><font color=\"#FF9900\">{$row['engineer']}</font></td>";
              }
          elseif ($row['engineerstatus'] == '1')
              {
              echo "<td align=\"center\"><font color=\"green\">{$row['engineer']}</font></td>";
              }
          elseif ($row['engineerstatus'] == '2')
              {
              echo "<td align=\"center\"><font color=\"red\">{$row['engineer']}</font></td>";
              }
            
echo "</tr>


I was wondering if there is a better way of doing this as I think including this many ifesle statements in a while loop that could go round about 40 times might be very heavy on the resources.

Thanks

My code here

Code: [Select]
  setcookie('hide_div', $_COOKIE['hide_div'].','.$_GET['hide'],time()+32000000);
When I set it, it works wonderful, but then when I see view it in my cookie it shows this code between my $_GET['hide'] values

Code: [Select]
%2C
how do I clean it up and just make it show my " , "?

Thank you