verify text in field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is there a shorter way of determining if a field contains text?
This works but I wonder if I can K.I.S.S. it? I really only need to know
if there is or is not a field containing the text specified. I don't
need to see it.
<?php
 
  // Request the text
  $text = "Joe of Egypt";
  $sql = "SELECT title FROM book WHERE title LIKE '$text'";
  $result = mysql_query($sql);
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

  // Display the text
  while ( $row = mysql_fetch_array($result) ) {
    echo("<P>" . $row["title"] . "</P>");
  }
  if ($row["title"] == "")
      echo ("Empty!")

?>

-- 

Phil Jourdan --- pj@xxxxxxxxxxxxx
   http://www.ptahhotep.com
   http://www.chiccantine.com


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux