Ashley M. Kirchner wrote:
<?php
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$mins[] = $row['the_minute'];
$temp_f[] = $row['avg_temp_f'];
$temp_c[] = $row['avg_temp_c'];
}
?>
I'd try php here, something like:
<?php
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$mins[] = empty($row['the_minute']) ? 'blank value' :
$row['the_minute'];
$temp_f[] = empty($row['avg_temp_f']) ? 'blank value' :
$row['avg_temp_f'];
$temp_c[] = empty($row['avg_temp_c']) ? 'blank value' :
$row['avg_temp_c'];
}
?>
Of course, you'd want to replace blank value with whatever a blank
record is (0, '', etc.).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]