Question: good am.
i have a query that needs a value upon submission.. here it is

```
<?php
$conn = mysql_connect("localhost","root","");

mysql_select_db('irm',$conn);

if(isset($_GET['Submit'])){
$customer_date = $_GET['customer_date'];
}
?>
<?php

$tryshow =" SELECT c.customer_date, c.lastname, c.firstname,
   s.room_number, s.date_in, s.date_out
FROM customers c
    INNER JOIN services s
        ON c.customer_date = s.date_in
 WHERE c.customer_date = '$customer_date'";

$result = @mysql_query($tryshow,$conn)
            or die(mysql_error());

if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print...";
}
while($row=mysql_fetch_assoc($result)){ 
?>

```

i think my problem is that even i submit a date the $customer\_date doenst hold any value and thus leading to my no rows found echo...

need some of your advice and thanks in advance hope you can help me soon
-renz

Answer: 
Try calling `invalidate()` on your ListView.
I encountered the same problem, and I tried to call `notifyDataSetChanged()` on the adapter. Besides, I also tried to call `refreshDrawableState()`, `invalidateViews()` on the view and none of those worked. All these methods are called in the UI thread. Then I found this [How to clear the views which are held in the ListView's RecycleBin?](https://stackoverflow.com/questions/12049198/how-to-clear-the-views-which-are-held-in-the-listviews-recyclebin/16261588#16261588) . Finally `setAdapter()` worked, only if I create a new adapter.