PHP & SQL - outputting messages

[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";

    }

  ?>

[AndyB]

The test for equality is ==.

 

if (whatever == something)

[pak4eva]

The test for equality is ==.

 

if (whatever == something)

 

i've tried something similar but unforunately no luck.....

[AndyB]

similar? how 'similar'.

 

Can you post the current version of your code and use the CODE tag to show it instead of all the strikethough stuff.  Is the content of the field null or NULL or ... why not just have it empty.

[pak4eva]

This is what im currently using...

 

<?php

    {$query = "Select Imagename1, Imagename2

              From Element

              Where Symbol ='$_GET'";

    IF (Imagename1 = "NULL")

              {

              echo("No image available");

              }

 

[Lytheum]

You'll want to use

 

IF (Imagename1 == "NULL")

 

instead. When you're comparing things, always use '=='. Then..

 

$row = mysql_fetch_array($query);
$imagename = $row['Imagename1'];
if ($imagename == "NULL")
              {
               echo("No image available");
              }

 

 

 

[pak4eva]

You'll want to use

 

IF (Imagename1 == "NULL")

 

instead. When you're comparing things, always use '=='. Then..

 

$row = mysql_fetch_array($query);
$imagename = $row['Imagename1'];
if ($imagename == "NULL")
              {
               echo("No image available");
              }

 

Thanks a lot mate, but considering my code below where do i need to insert the above?

 

<?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";

    }

  ?>

[Lytheum]

Replace

 

    IF (Imagename1 = "NULL")
              {
               echo("No image available");
              }

 

With it.

[pak4eva]

sorry to be pain mate but im getting an error "unexpected T_STRING on line......... the line its refereing to is

 

$result = mysql_query($query) or die ("error in Query: $query. " .mysql_error());

 

[Lytheum]

Oh, should be

 

echo "No image available";

[pak4eva]

i still get the same error mate, can you do me a favor please and insert that code into the my code so i can see how it work.... Thanks

[AndyB]

 <?php 
    {$query = "Select Imagename1, Imagename2 
              From Element 
              Where Symbol ='$_GET'";
     IF (Imagename1 = "NULL")
              {
               echo("No image available");
              }
}

 

Heaven knows what that's all about.  Why do you issue a second <?php when you're already in php code?  What are the curly braces about???  Symbol = $_GET ... what? Where is the query executed, etc.

 

Assuming this page is called from some link like mypage.php?Symbol=wombat, then your code would probably look like this ...

 

$symbol = $_GET['Symbol'];
$query = "Select Imagename1, Imagename2 From Element Where Symbol ='$symbol'";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);
$row = mysql_fetch_array($result);
if ($row['Imagename1'] == "NULL") {
    echo "No image available";
} else {
// do something else
}