help with if ( ) statement

[Anon]

hello, all- I could use some help with a small thing that is really causing a terrible time.

I have a column in a database that is titled 'dirname'.This the the name of the directory that I store images in. Now, since not all of my db records have images associated with them, many times, this field is left blank.

After a select statement, I need to use an if/else statement to do different things depending upon whether or not this 'dirname' field is populated or not. If it's empty, cool- echo "empty";. If it's populated, echo the data.

I will passing the record id to the query such as:
$result = mysql_query("SELECT * FROM a_table WHERE (id='$id')",$db);

Any help with this would be appreciated. Thanks for your time.

Rainmaker.

[Anon]

$result = mysql_query("SELECT * FROM a_table WHERE (id='$id')",$db);

while ($row = mysql_fetch_array($result)) {
if ($row["dirname"] != "") [
//field is empty do whatever
}
else {
//field is not empty and do whatever
}

}

[Anon]

Louie wrote:

$result = mysql_query("SELECT * FROM a_table WHERE (id='$id')",$db);

while ($row = mysql_fetch_array($result)) {
if ($row["dirname"] != "") [
//field is empty do whatever
}
else {
//field is not empty and do whatever
}

}

NO!!! exacly the oposite... like this:

if ($row["dirname"] != "") {
//field IS NOT empty do whatever
}
else {
//field IS empty and do whatever
}