help with sql + php

[pak4eva]

Hi guys

 

Ive managed to connect my sql database using php but the problem im coming across is outputing a message if something equals to null, i.e. i have an attribute in the database called 'Imagename1' so what i want to do is print out a message saying 'no image exist'

 

Imagename1 = 'NULL' ...... output message 'no image exist'.

 

The code im using is below, your help will be very much appreciated....

<?php 
    $host ="?";
    $user = "?";
    $pass = "?";
    $db= "?";

    // Connects to your Database 
    $connection = mysql_connect("$host", "$user", "$pass") or die("Unable to connect"); 
    mysql_select_db("$db") or die("Unable to select database"); 
    
  <?php 
    {$query = "Select Imagename1, Imagename2 
              From Element 
              Where Symbol ='$_GET'";
     IF (Imagename1 = "NULL")
              {
               echo("No image available");
              }
}
    $result = mysql_query($query) or die ("error in Query: $query. " .mysql_error());
     if (mysql_num_rows($result)>0)
     {
      echo "<table border=0 cellpadding=0 cellspacing=0>";
     while($row= mysql_fetch_row($result))
      {
       echo "<tr>";
       echo "<td>" . $row[0]. "</td>";
       echo "<td>" . ' '. "</td>";
       echo "<td>" . $row[1]. "</td>";
       echo "</tr>";
      }
      echo "</table>";
     }
     else
     {
      echo "No rows found";
     }
   ?>

[mgs019]

Hi,

 

One comment is that I think you should use the comparison operator == not the assignment operator =. I tend to use if(str_len($whatever)<1){} because I have had funny results with == null and isset()

 

Martin