in my function that displays rows( its on the front page by the way at http://ap-gfx.com) but at the bottom 2 rows their is no data i dont know what caused it please help

Show the code. Nobody knows how does your function behave and look like.

PHP Code:

function ListArticle()
  {
   $mysql = @mysql_connect( "localhost", "USER", "PASSWORD" );
 
   @mysql_select_db( "MY_DB" ); 
   
   if( !isset( $_GET['category'] ))
   { $sql = "select * from articles order by date_added"; }
   else
   {
    $cat = $_GET['category'];
    $sql = "select * from articles where category='$cat' order by date_added";
    
   }
   if( isset( $_GET['category'], $_GET['subcategory'] ) )
   {
    $cat = $_GET['category'];
    $sub = $_GET['subcategory'];
    $sql = "select * from articles where category='$cat' and subcategory='$sub' order by date_added";
    }
   
   $query = mysql_query( $sql ) or die( mysql_error());
   
   while( $row = mysql_fetch_array( $query ) )
   {
    $title = $row['title'];
    $image = $row['thumb'];
    $text = $row['text'];
    $author = $row['author'];
    $date = $row['date_added'];
    $cat = $row['category'];
    $subcat = $row['subcategory'];
    $id = $row['id'];
    
    
    echo( "<div class=\"listing\">");
    echo("<div class=\"image\">".$image."</div>");
    echo("<div class=\"textfloat\">");
    echo("<div class=\"title\"><b><a href=\"http://ap-gfx.com/article/id/".$id."\">".$title."</a></b></div>");
    echo("<div class=\"description\">".substr($text, 0, 120)."...</div>");
    echo("<div class=\"info\">author: ".$author." Date: ".$date." category: ".$cat." subcategory: ".$subcat."</div>");
    echo("</div>");
    echo("</div>");
   }
   
  } 


Obviously you have two empty rows in your table.

I know that but they keep appearing as i have deleted them and they keep coming back a couple of days later.

Obviously you need to check the code which is responsible for adding records into that table.

Its nots the code responsible for inserting records as the records appear a few days later.
p.s could you please stop starting every post with obviously

Well, in this case you deal with some kind of god power that adds records to your table.

Why should I stop starting each post with obviously if you are talking about things which are obvious? Your code definitely shows that there are no extra actions on your data array except selecting and echoing. If additional records appear in your table then they are inserted somewhere, find and fix it.

Originally Posted by mtishetsky

Why should I stop starting each post with obviously if you are talking about things which are obvious?

Because your responses aren't obvious to people who don't understand what you are trying to explain

Rather than find the bug thats adding the rows and waiting to see if you fixed it, make some If...Else conditions to read the data of the row to be added. If its blank, just skip that row.

Hope that would apply to your layout though, I don't see any missing rows (perhaps you fixed it already?)

I always laugh a bit when someone says "obviously". Being a math dude, I was advised that "obviously" should almost never be used. Is it "obvious" that an even added with an even is also even? To you and I, perhaps, but mathematically-speaking, one must prove it. It may be "apparent", but only to those for whom training has been sufficient that the analysis is apparent.

Now, as for the error, it is likely that the insert script (which isn't given here) is inserting blank rows. Provide that and maybe we can be of additional assistance.

thanks, i will just do a bunch of if statements to do the displaying. the reason you cant see it anymore was i didnt want anyone to watch a site being built, so i stuck a redirect to my blog.


p.s about the controversy i've cause with the word "obviously" RadGH new why its annoying, also it make me feel kind of stupid