Re: mysql if empty
| From: | tedd | Date: | Wed, 11 Apr 2007 21:13:10 +0000 |
| Subject: | Re: mysql if empty | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-252634@lists.php.net to get a copy of this message | ||
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 -- ------- http://sperling.com http://ancientstones.com http://earthstones.com