Re: mysql if empty

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

 



No.

Despite the fact that I replied to your message as it was the "last"
one, and that caused threaded mail readers to place my post directly
under yours as a "reply", my comment was not specifically directed at
your post.

I had deleted the "way wrong" posts by the time I realized I wanted to
say something about them...

Apologies that my email/reading/posting habits are only somewhat
conformant with threaded readers...

Damn!  And I just top-posted too! :-v

On Tue, April 10, 2007 7:53 pm, Jim Lucas wrote:
> Richard Lynch wrote:
>> I am amazed by the sheer number of just plain WRONG answers to this
>> one...
>>
>> Were they all from April 1 or something?...
>>
> so, are you saying that my answer was wrong, or just making a
> statement.
>
> If my answer was wrong, it was because it was too simple, which is
> what I was trying to get at, so
> as not to confuse the OP.
>
> 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?
>
>
>


-- 
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
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