Re: empty variable if/then
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Tue, 28 Feb 2006 17:15:45 -0500
Mikey P wrote:
Hi there, i'm trying to figure out if there is an empty variable in a
search to return an alternative result...
like:
$query = mysql_query("SELECT * FROM db WHERE city='$city2' AND
state='$state2' ORDER BY title");
while($row = mysql_fetch_assoc($query)){
if (empty($url)) {
echo($row['title'] . '<br>');
} else {
echo
echo('<b><a href="' . $row['url'] . '>' . $row['title'] . '</a></b>');
}
}
from what it looks like it seems to be searching and saying if there is
any result that is empty in $url return this result. I guess i need to
know how to say.. if there is an empty $url on this row return this
result if there isn't then return the other. :) hope that makes some
sort of sense... Sorry i'm still fairly new at this.
Mikey,
It depends on the contents of the column 'url'. It could be null, or it could be a zero length string ("").
If you insert null values when there is no URL, then you should use
if(is_null($row['url']) ...
If it's an empty string, it could still be padded with blanks, so you can use something like
if (empty(trim($row['url'])) ...
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.
- References:
- empty variable if/then
- From: Mikey P
- empty variable if/then
- Prev by Date: Re: file which tries to find itself and can't...
- Next by Date: Re: Cannot instantiate non-existent class
- Previous by thread: Re: empty variable if/then
- Next by thread: Paradox and PHP 5.1.2
- Index(es):
Relevant Pages
|
