Re: mysql if empty

From:	Jim Lucas	Date:	Thu, 12 Apr 2007 00:43:21 +0000
Subject:	Re: mysql if empty
References:	1 2 3 4 5 6 7 8 9 10 11 12 13	Groups:	php.general
Request:	Send a blank email to php-general+get-252656@lists.php.net to get a copy of this message

tedd wrote:

At 5:53 PM -0700 4/10/07, Jim Lucas wrote:
Anyways, here is the expanded version hopefully to your liking. <?php // do that db connection thing... // select you database $sql = "SELECT
        Client
    FROM
        booked
    WHERE
        Name = 'larry'
"; if ( ( $result = mysql_query($sql) ) === false ) {
    # Your request failed.  Make up your own custom way of displaying the error.
} else {
    if ( mysql_num_rows($results) > 0 ) {
        while ( $row = mysql_fetch_assoc($result) ) {
            if ( isset($row['client']) && !empty($row['client']) ) {
                echo $row['client'] . '<br />';
            }
        }
    } else {
        echo 'No results found!';
    }
} ?> Does this satisfy you?
Actually, it's $result and not $results. Other than that, it works fine as far as I can tell. Cheers, tedd good catch, missed that.

Thanks