php and mysql record delete problem

[ahsan1]

I have used the delete query
$sql="DELETE FROM table_name WHERE id='$ids'";
but the problem isthat it deletes the record but the record does not disappears from the page. It dissappears after refreshing the code. I have used the meta tag for page refresh but itis not working. Can any one help me. I'll be thankful to you.

[lyrico]

Just place the delete query into the top of display query.

Sample

<?php

$sql="DELETE FROM table_name WHERE id='$ids'";

$query=mysql_query("select * from tbl_name");
while($result=mysql_fetch_array($query))
{
   //blah blah blah
}