Not reading from the table

[proph]

<?php
// Discography
if ($GET['category_id']==3){
// $query="SELECT * FROM disco LIMIT 0 , 30 ";
$query="select disco_title,disco_tracklistings
from disco
where disco_category_id='3'";
//$query="select disco_id,disco_title,disco_year,disco_company,disco_pic_id,disco_tracklistings
// FROM disco
// where disco_category_id=".$GET['category_id'];
$result=mysql_query($query,$connect);
for($i=0;$i<mysql_num_rows($result);$i++){
// list($disco_id,$disco_title,$disco_year,$disco_company,$disco_pic_id,$disco_tracklistings)=mysql_fetch_row($result);
list($disco_title,$disco_tracklistings)=mysql_fetch_row($result);
echo '<h1>$disco_title</h1>
<h2>$disco_tracklistings</h2>';
}
}
?>

Can't find error.

Its not reading from the table [ "Warning: mysql_num_rows(): supplied argument is not a valid MySQL"].

[planetsim]

Usually you get those with a bad Query that returns false.

<?php
// Discography
if ($_GET['category_id']==3){
    // $query="SELECT * FROM `disco` LIMIT 0 , 30 ";
    $query="select disco_title,disco_tracklistings from disco where disco_category_id='3'";
//$query="select disco_id,disco_title,disco_year,disco_company,disco_pic_id,disco_tracklistings
// FROM disco
// where disco_category_id=".$_GET['category_id'];
	$result=mysql_query($query);
	for($i=0;$i<mysql_num_rows($result);$i++){
	//list($disco_id,$disco_title,$disco_year,$disco_company,$disco_pic_id,$disco_tracklistings)=mysql_fetch_row($result);
	list($disco_title,$disco_tracklistings)=mysql_fetch_row($result);
	echo '<h1>$disco_title</h1>
	<h2>$disco_tracklistings</h2>';
	}
}
?> 

Try that maybe

[proph]

u think maybe I set up my sql table incorrectly.