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