let say i have a table 'tasks' where:-

uemail-varchar(50)PKey
name-varchar(50)
task_date-DATE

PHP Code:

<?php
//This is a recordset named taskset:

30 $task_date="2005/06/10";
31 $xuemail="abc@asd.com";

33 mysql_select_db($database_myodbc, $myodbc);
34 $query_taskset = "SELECT * FROM tasks WHERE task_date='$task_date' AND uemail='$xuemail'";
35 $taskset = mysql_query($query_taskset, $myodbc) or die(mysql_error());
36 $row_taskset = mysql_fetch_assoc($taskset);
37 $totalRows_taskset = mysql_num_rows($taskset);

39 if($totalRows_taskset){ //if recordset taskset's row is not empty
40 ?>
41        <li><? echo $row_taskset['name']; ?></li><br>
42 <?
43 }
44 }while($row_taskset = mysql_fetch_assoc($taskset));
45 ?>

I use this code to display the "$row_taskset['name']"
for certain date. For example, in the table,
date="2005/06/10" I have name="joe".
for date="2005/06/09" I have name="mike".
Suppose it only display "joe", but instead it
displays..

joe
mike

.I'm not quite sure about line 39 and 44.

Is that the whole code? What you have there shouldn't even parse. You either need a do { somewhere to match the } while (), or you need to change to another type of loop structure. Are there going to be multiple names for a given date, or always only one?

I'd probably rewrite it like this:

PHP Code:

<?php
//This is a recordset named taskset:

$task_date="2005/06/10";
$xuemail="abc@asd.com";

mysql_select_db($database_myodbc, $myodbc);

$taskset = mysql_query("SELECT * FROM tasks WHERE task_date='$task_date' AND uemail='$xuemail'", $myodbc) or die(mysql_error());
while($row_taskset = mysql_fetch_assoc($taskset)) { 
echo "<li>".$row_taskset['name']."</li><br>";
}
?>

Sorry...its not the entire code. But i'll try yours and see what happen. Thanks.