Shawn McKenzie wrote:
> PJ wrote:
>> 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!")
>>
>> ?>
>>
> // Request the text
> $text = "Joe of Egypt";
> $sql = "SELECT title FROM book WHERE title LIKE '%$text%'";
> $result = mysql_query($sql);
> if (!$result) {
> die("<P>Error performing query: " . mysql_error() . "</P>");
> }
> if (mysql_num_rows($result) > 0) {
> // you found text
> }
>
Not relevant to your question, but you should be able to shorten it up
more like this:
--instead of this:
$result = mysql_query($sql);
if (!$result) {
die("<P>Error performing query: " . mysql_error() . "</P>");
}
--try this:
$result = mysql_query($sql) or die("<P>Error performing query: " .
mysql_error() . "</P>");
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
