[Resolved] Strange behaviour from database

[dmnet]

hi,

I am working on a site at the moment that is for property developments. The page where the user can view details of a development works fine for 3 of the 4 records in the developments table on the db but for some reason, and i have tried to sort it, id# 3 breaks the page. example:

require_once("../conn/pickstock_con.php");
include("_inc/header_homes.php");

// all of the html & php below the header file is not processed
include("_inc/dev_sql.php");
/********** code from dev_sql.php ******
$dev = $_GET['development'];

// check the $_GET vars are set otherwise use the default Spoonley Farm
if(!$dev) { $dev = "Spoonley Farm"; } else { $dev = urldecode($dev);}

$error = "Sorry, there appears to have been an error. Please try later or email [email][e-mail][/email]";
 $qr_devselect = mysql_query("select * from tbl_developments where dev_name = '$dev'");
 $qd_devselect = mysql_fetch_array($qr_devselect) or die(mysql_error());

 $dev_select = $qd_devselect['dev_code'];

 $qr_devimg = mysql_query("select * from tbl_dev_images where dev_code = '$dev_select'");
 $qd_devimg = mysql_fetch_array($qr_devimg) or die(mysql_error());

 $qr_priceguide = mysql_query("select dp_num, dp_price, dp_bed, dev_code from tbl_dev_plot where dev_code = '$dev_select' order by rand() limit 4");
 $qd_priceguide = mysql_fetch_array($qr_priceguide) or die(mysql_error());

$qr_locam = mysql_query("select * from tbl_dev_amenities where dev_code = '$dev_select'");
$qd_locam = mysql_fetch_array($qr_locam) or die(mysql_error());

$q_features = "
	SELECT
 	tbl_feature_categories.fc_id,
	tbl_feature_categories.fc_name,
	tbl_dev_features.*,
	count(tbl_dev_features.dev_code) as num
	FROM tbl_dev_features, tbl_feature_categories
	WHERE tbl_dev_features.dev_code = '$dev_select' 
	AND tbl_feature_categories.fc_id = tbl_dev_features.fc_id
	GROUP BY tbl_feature_categories.fc_id
	ORDER BY tbl_feature_categories.fc_id ASC"; 
 $qr_features = mysql_query($q_features) or die(mysql_error());
 $qd_features = mysql_fetch_array($qr_features);

$dev_code = $qd_devselect['dev_code'];
$q_docs = "
	select doc_id, doc_file, dev_code
	from tbl_dev_documents where
	dev_code = '$dev_code' limit 1";
$qr_docs = mysql_query($q_docs) or die(mysql_error());
$qd_docs = mysql_fetch_array($qr_docs);

*********************/
include("../inc/top_nav_html.php");

page content here

include("../inc/footer.php");

I am at a loss. there are 4 records stored in the db but only 1, 2, & 4 are working right on this particular page. other areas of the site show the relevant content fine!

any help would be appreciated!

cheers

Dave

[dmnet]

since posting this, i have worked out that it is to do with a sql query for a table that stores the prices of each property under a specific development. this table has no records for the development in question. having added one price, the page displays fine.

sorry if i wasted anyones time!

cheers

Dave