Newbie

Anon

Hi there,
i'm very new to this PHP caper.
Now for the question....how would i write an else statment in the following example?

<?
$link = mysql_connect('localhost', '', '');
mysql_select_db('name');
$query = "select * from list WHERE date = '$dates'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){

echo "<TR>";
echo "<TD>Date: {$row['date']}";
echo "</TD>";
echo "</TR>";

}
?>

If the {$row['date']} is not active how do i write the else statement to say "No data available?

Cheers,
rhett

Anon

http://www.php.net/manual/en/control-structures.else.php

"$row['date'] not active"? You mean if the $result contains no records?

$result=mysql_query($query);
if($mysql_num_rows($result)==0)
{
echo '<tr><td>No data available</td></tr>';
}
else
{ while()....
}

Anon

Do you mean you want to check if $row['date'] has a value ?

If so ...

$row_date = $row['date'];
if ($row_date == "") {
echo "no data";
} else {
echo $date;
}

Anon

while($row = mysql_fetch_array($result)){
if ($row[date] == "") {
echo "<TR>";
echo "<TD>NO DATA ENTERED!";
echo "</TD>";
} else {
echo "</TR>";
echo "<TR>";
echo "<TD>Date: {$row['date']}";
echo "</TD>";
echo "</TR>";
}
}