some help with good ol NOT NULL?

[Spud]

Hi
I have a little query that goes through a table and grabs the data I ask for but some times it doesn't get any data so I wanted to add a NOT NULL value. I think this is where it should be added...
$query = "SELECT cat, url from galleries WHERE cat = '{$cat}'";

I've tried = '{$cat}' AND IS NOT NULL";
and a few other obviously wrong queries.

Any thoughts? or should I list the whole query here?

thanks

[LordShryku]

try

SELECT cat, url
FROM galleries
WHERE cat = '$cat'
AND cat is NOT NULL";

[Spud]

Hey, Thanks LordShryku
but it doesn't seem to do the trick. Here's the rest of the code if it helps

	// Database Variables
		$mysql_host = "localhost";
		$mysql_user = "user";
		$mysql_pass = "pass";
		$mysql_db = "db";

	// Open DB Connection
		mysql_connect( $mysql_host, $mysql_user, $mysql_pass );
		mysql_select_db( $mysql_db );

$cat_text="categories";

$c=explode("|",$cat_text);
$c_n=count($c);

for ($i=0; $i<$c_n; $i++) {
	getgals($c[$i]);
}


function getgals($cat) {
GLOBAL ${$cat};

		$query = "SELECT cat, url, des from galleries WHERE cat = '{$cat}' AND cat is NOT NULL";
		$galleries=mysql_query($query) or die("Bad Query!");

		while ($g_temp[] = mysql_fetch_array($galleries)) {
		/* ...... */
		}

		${$cat} = array();
		$total=count($g_temp);

		for ($i=0; $i<$total; $i++) {
			${$cat}[$i] = " <a href='" . $g_temp[$i][1]  . "'>" . $g_temp[$i][2] . "</a><br>";
		}

		shuffle(${$cat});

}


$a=0;

[LordShryku]

You should get the actual error it's giving you.

$galleries=mysql_query($query) or die("Error in Query:" . mysql_error($connection);