Query not working.. but it is fine :S

[boo_lolly]

dude, your db structure is NOT fine. i don't care what details you can't illustrate... your db structure is messed up. i can't help you dig yourself into a deeper hole. however, you may be able to apply my code to your db structure... i pretty much just omitted your 'last_post' column, practically everything else is the same. why don't you try that and let us know how it works out.

[rockinaway]

I will have to check with the lead developer before I do that..

[HaLo2FrEeEk]

if(isset($_GET['file']) {
  $file = $_GET['file'];
  $query = mysql_query('SELECT parent, last_post FROM test_boards WHERE id = \''.$file.'\'')or die("Error:" . mysql_error());
  $results = mysql_results($query, 0);
  } else {
  // some code is $_GET['file'] is not set
  }